What is pseudo column ?

Answer Posted / mail2sentha

pseudo column is a act as an database table column,but its
not a actual column in a table,we can fetch value from a
pseudo column.
ex.
user,usid,rownum,rowid,level,nextval,curval,sysdate

Is This Answer Correct ?    29 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many functions are there in sql?

774


How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1018


Is sql open source?

766


Is primary key clustered index?

733


How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

1940


What is difference between cursor and trigger?

823


How many indexes can be created on a table in sql?

746


What packages(if any) has oracle provided for use by developers?

5426


What is informix sql?

771


What is sql integrity?

829


What is the difference between local variables and global variables?

862


What is difference between sql function and stored procedure?

749


Explian rowid, rownum? What are the psoducolumns we have?

810


What is null in pl/sql?

858


What do you mean by field in sql?

867