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
What is before trigger?
What is primary and foreign key?
What is the usage of nvl function?
Can we use joins in subquery?
Why do we need pl sql?
what is “go” in t-sql? : Transact sql
Explain the order of sql statement execution?
When is a declare statement required?
Can function return multiple values in sql?
where are cookies actually stored on the hard disk? : Sql dba
Is sql open source?
How you improve the performance of sql*loader? : aql loader
What are tables and fields?
When you have to use a default "rollback to" savepoint of plvlog?
Explain the difference in execution of triggers and stored procedures?
