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...") |
|||
(One intermediate revision by the same user not shown) | |||
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=== | ||
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]] |
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