3 Pseudocolumns

A pseudocolumn behaves like a table column, but is not actually stored in the table. You can select from pseudocolumns, but you cannot insert, update, or delete their values.

This chapter contains the following sections:

• Hierarchical Query Pseudocolumns

• Sequence Pseudocolumns

• Version Query Pseudocolumns

• OBJECT_ID

• OBJECT_VALUE

• ORA_ROWSCN

• ROWID

• ROWNUM

• XMLDATA