Difference between revisions of "TYPES OF PSEUDO COLUMNS"
Jump to navigation
Jump to search
| Line 14: | Line 14: | ||
===ROWNUM=== | ===ROWNUM=== | ||
It indicates a number indicating the order of row selected from a table | It indicates a number indicating the order of row selected from a table | ||
select rownum, rowid, salesdate from sales | |||
===ROWID=== | ===ROWID=== | ||
Latest revision as of 17:34, 13 November 2017
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