What is pseudo column ?

Answer Posted / senthilnathan

A pseudo column is an item of data which does not belong in
any particular table but which can be treated as if it did.
Any SELECT list of columns can include these pseudo
columns.
SYSDATE current date and time

ROWNUM sequence number assigned to retrieved rows

ROWID unique identifier for a row

UID number associated with a user

USER userid of current user

Is This Answer Correct ?    43 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

759


How to find 3rd highest salary of an employee from the employee table in sql?

831


What is sap sql anywhere?

701


What is cursor and why it is required?

836


Which tcp/ip port does sql server run?

750


When are we going to use truncate and delete?

748


What is memory optimized?

781


what are the advantages a stored procedure? : Sql dba

740


What is exit statement?

766


How to create your own reports in sql developer?

753


How does postgresql compare to oracle/db2/ms sql server/informix?

806


What does the sign mean in sql?

725


Can we join tables without foreign key?

716


how to get a list of all tables in a database? : Sql dba

722


What is a sql schema used for?

758