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

how to fetch common records from two tables? : Sql dba

633


what are the advantages of using stored procedures? : Sql dba

620


What will you get by the cursor attribute sql%notfound?

595


What are all the different types of indexes?

625


How do I truncate a sql log file?

538






How do I edit a trigger in sql developer?

541


What is a table?

569


What is rename command in sql?

467


what is a tablespace? : Sql dba

564


What type of join is sql join?

531


what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

547


Does mysql support pl sql?

624


What is the clause we need to add in function body to return variable?

540


Can delete statement be rollbacked?

527


What is pl sql quora?

649