What is pseudo column ?

Answer Posted / nagarjuna reddy

A pseudo column is a column but it is not physically existed
in the table.if we want to use these column by specifying
externally in select statement for projection or selection.
but we can't insert,delete and update pseudo columns.
some of pseudo columns are
1 ROWID
2 ROWNUM
3 LEVEL
4 CURRVAL
5 MEXTVAL
etc...

Is This Answer Correct ?    9 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between the sql*loader and import utilities? : aql loader

793


what is oracle database ? : Sql dba

772


What is the basic structure of an sql?

795


Can a table have no primary key?

817


What is pl sql in dbms?

724


Can %notfound return null after a fetch?

789


what are the difference between clustered and a non-clustered index? : Sql dba

770


What is substitution variable in pl sql?

731


Define concurrency control. : Transact sql

836


Which command is used to delete a package?

819


Explain the steps needed to create the scheduled job?

784


when MSQL8.0 is in market

1811


How do I run a script in sql developer?

731


what is a constraint? : Sql dba

904


Define overloaded procedure?

832