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

Which one is better subquery or joins?

828


What are properties of the transaction?

776


What is data type in database?

771


Is sql procedural language?

769


How many types of keys are there in sql?

804


How do I start sql profiler?

782


What sql database should I use?

855


What is the left table in sql?

743


Which is better stored procedure or query?

759


how to increment dates by 1 in mysql? : Sql dba

774


What is query syntax?

763


What is nvl?

840


What is java sql connection?

758


How to run sql*plus commands in sql developer?

845


Which is faster view or stored procedure?

728