The SQL syntax elements for Oracle Version 7 and SAP MaxDB in the ORACLE SQL mode differ, among other things, in the definition of namespaces.
Oracle 7 |
SAP MaxDB |
---|---|
All indexes of a database instance form a namespace. |
All indexes of a table form a namespace. |
All constraints of a database instance form a namespace. |
All constraints of a table form a namespace. |
All triggers of a database instance form a namespace. |
All triggers of a table form a namespace. |
All sequences, together with the tables, views, synonyms, procedures, and further objects, form a namespace. |
All sequences of a database instance form a separate namespace. |
All procedures, together with the tables, views, synonyms, and further objects, form a namespace. |
All database procedures of a database instance form a separate namespace. |