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.