Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Data-Sync Are double quotes required? Joins

Received Response
13
Views
1
Comments

Summary

Are the double quotes required when writing joins in DS

Content

Team, when writing a JOIN in Data-Sync are the double quotes required?

Version

2.5

Answers

  • User743400-Oracle
    User743400-Oracle Rank 3 - Community Apprentice

    No, not really.  As long as the Join is an accepatable SQL-part, you dont have to.  You need double quotes if the table name has lower case naming convention (for example "mytable") or has spaces in the name (for example "MY TABLE").