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

how to get help information from the server? : Sql dba

528


Do stored procedures prevent sql injection?

550


explain mysql aggregate functions. : Sql dba

549


What is a crud api?

502


What is a .db file?

544






What is the current version of sql?

540


How does postgresql compare to "nosql"?

581


What is sql and how does it work?

549


What is difference between nchar and nvarchar?

545


Does sql profiler affect performance?

557


How do you exit in sql?

590


What is an oracle stored procedure?

592


Can we use join in subquery?

567


What is online transaction processing (oltp)?

604


When should I use nosql database?

553