Difference between revisions of "TYPES OF PSEUDO COLUMNS"
Jump to navigation
Jump to search
(Created page with "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...") |
|||
Line 17: | Line 17: | ||
===ROWID=== | ===ROWID=== | ||
Returns the rowid(binary address) of a row in a database table | Returns the rowid(binary address) of a row in a database table | ||
[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] |
Revision as of 17:32, 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
ROWID
Returns the rowid(binary address) of a row in a database table