TYPES OF PSEUDO COLUMNS

A pseudo-column is an Oracle assigned value (pseudo-field) used in the same context as an oracle database column, but not stored on disk

SYSDATE

Returns the current date

SYSTIMESTAMP

Returns the current Timestamp (Date + Time)

USER

Returns the user name who is currently running sql

ROWNUM

It indicates a number indicating the order of row selected from a table

select rownum, rowid, salesdate from sales

ROWID

Returns the rowid(binary address) of a row in a database table

Back To Top- Home - Category