Pseudo Column

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

·        The pseudo column LEVEL is not supported in MaxDB.

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

·        In 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.