DEVFYI - Developer Resource - FYI

What is pseudo columns ? Name them?

ORACLE Interview Questions and Answers (Part 4)


(Continued from previous question...)

627. What is pseudo columns ? Name them?

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 section describes these pseudocolumns:
* CURRVAL
* NEXTVAL
* LEVEL
* ROWID
* ROWNUM

(Continued on next question...)

Other Interview Questions