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 null value, zero, and blank space?

556


Why are indexes and views important to an organization?

525


What is the difference between inner join and left join?

541


What are the types of variable use in pl sql?

563


what is an extent ? : Sql dba

580






Explain ddl statements in pl/sql?

576


What is the primary use of normalization?

520


Explain the insert into statements in sql?

561


What is cross join sql?

494


How much ram can sql express use?

503


What is the sql*loader? : aql loader

585


What pl/sql package consists of?

633


what are null values? : Sql dba

542


What are reports usually used for?

564


What do you mean by stored procedures? How do we use it?

517