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 are the advantages and disadvantages of cascading style sheets? : Sql dba

547


How to start the command-line sql*plus?

562


What does sql stand for?

542


What is AUTH_ID and AUTH_USER in pl/sql ?

1689


How to add a column ‘salary’ to a table employee_details?

583






What are keys in sql?

544


What is the cause of mutating table error and how can we solve it?

596


what are the nonstandard string types? : Sql dba

601


Does sql view stored data?

534


What is trigger price?

538


What is difference between stored procedures and application procedures?

567


Why is sql important?

576


What is constant in pl sql?

515


How many commands are there in sql?

545


What is pivot query?

591