Show TOC

Background documentationPseudo Column

 

The SQL syntax elements for Oracle Version 7 and SAP MaxDB in the ORACLE SQL mode differ, among other things, in the definition of pseudo columns.

  • The pseudo column LEVEL is not supported in SAP MaxDB.

  • The pseudo column ROWID can only be used if the option ROWID was specified in the CREATE TABLE statement. In contrast to Oracle, SAP MaxDB produces a logical column identification of the data type RAW(8).

  • In SAP MaxDB, pseudo column ROWNUM cannot be used in the UPDATE statement.

  • The pseudo column ROWNUM is entered into a selected column (select_column) after the result table has been sorted.

More Information

SQL Syntax Elements: Differences