TYPES OF PSEUDO COLUMNS

From rbachwiki
Revision as of 17:32, 13 November 2017 by Bacchas (talk | contribs)
Jump to navigation Jump to search

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

CURRVAL, NEXTVAL

ROWNUM

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

ROWID

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


Back To Top- Home - Category