TechView with Kamlesh khaliya

Resources for OCP, Oracle Interviews(kamleshkhaliya@gmail.com)

Wednesday 14 March 2012

What are the pseudo columns in Oracle?



A Pesudo column is not actual column of any database table, it only behave like a table column and you can select pesudo column values for a table but you can not perform insert, update or delete for a pseudocolumn. Oracle supporting many pseudo columns, some of those are :

CURRVAL
NEXTVAL
LEVEL
ROWID
ROWNUM
ORA_ROWSCN
OBJECT_ID
For more details visit to Oracle.com :

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home