Identifier Convention

The following convention must be followed for Oracle identifiers:

  • In all SQL queries, the table names, column names must be specified in the exact case as stored in Oracle Database. Schema retrieval fails if exact case is not provided.
  • Use of aliases for functions is mandatory.
  • All the aliases used in a query must be enclosed in double quotes.