What is pseudo column ?

Answer Posted / nazeer

pseudo column act as database table column, but not actually the exact column in the table....we can fetch values from the pseudo column....

The Columns are..
user,
userid,
rownum,
rowid,
level,
nextval,
curval,
sysdate.......

Is This Answer Correct ?    14 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Cite the differences between execution of triggers and stored procedures?

875


What is delimiter in pl sql?

789


Why do we use partitions in sql?

769


How does stored procedure reduce network traffic?

773


How do I edit a trigger in sql developer?

741


What is the difference between database trigger and stored procedure?

793


What is the difference between the implicit and explicit cursors?

789


What is exception? What are the types of exceptions?

828


What are the different schemas objects that can be created using pl/sql?

774


Explain alias in sql?

804


Where can I learn sql for free?

737


what is user defined functions? : Sql dba

793


Is coalesce faster than isnull?

734


If the application is running very slow? At what points you need to go about the database in order to improve the performance?

787


What is tuple in sql?

778