What is a pseudo column. Give some examples?
What is a pseudo column. Give some examples?
✍: Guest
Information such as row numbers and row descriptions are automatically stored by Oracle and is directly accessible, ie. not through tables. This information is contained within pseudo columns. These pseudo columns can be retrieved in queries. These pseudo columns can be included in queries which select data from tables.
Available Pseudo Columns
· ROWNUM - row number. Order number in which a row value is retrieved.
· ROWID - physical row (memory or disk address) location, ie. unique row identification.
· SYSDATE - system or today’s date.
· UID - user identification number indicating the current user.
· USER - name of currently logged in user.
2011-11-23, 3196👍, 0💬
Related Topics:
What is a cursor?
What is a cursor? A cursor is a mechanism by which you can assign a name to a “select statement” and manipulate the information within that SQL statement. 2011-11-21, 3181👍, 0💬