Psudo colums

Answer Posted / mathan r

It is a column that is not an actual column in the table.
eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL.
rowid
versions_xid
versions_operation
versions_startscn
versions_endscn
sysdate
systimestamp
rownum
ora_rowscn
object_value
level
user

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which table keeps information about stored procedures?

539


Can a unique index be created on a column, which contains null?

527


How to modify an existing user defined function?

604


What is a database in ms sql server?

556


What is mean by candidate key?

552






Differentiate sql server reporting services vs. Crystal reports?

150


What is the language structure to add a record to a table?

581


What is the recovery model? List the types of recovery model available in sql server?

491


What happens if strings are casted into wrong code pages in ms sql server?

569


How do you create a data source?

480


What are the different types of sub-queries?

600


How do I perform an unattended install of sql server 2000?

604


what is the difference between delete table and truncate table commands? : Sql server database administration

527


What is difference between sql and sql server?

547


Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

619