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

• The pseudo column LEVEL is not supported in SAP DB.
• Pseudo column ROWID can only be used if the option ROWID was specified in the CREATE TABLE statement. In contrast to Oracle, SAP DB produces a logical column identification of the data type RAW(8).
• In SAP DB, 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.