TYPES OF PSEUDO COLUMNS
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
select rownum, rowid, salesdate from sales
ROWID
Returns the rowid(binary address) of a row in a database table