0 votes
in PL/SQL by
Explain what are Pseudo-columns? How Can You Use Pseudo Columns In Procedural Statements?

1 Answer

0 votes
by

Pseudo columns are not actual columns in a table but they behave like columns. They are used in SQL statements to retrieve specific information. PL/SQL recognizes pseudo-columns as a part of SQL statements but they cannot be used directly in a procedural language. The following pseudo-columns are used in SQL:

  •  ROWID
  •  ROWNUM
  •  LEVEL
  •  CURRVAL
  •  NEXTVAL
...