Interested to Buy Any Domain ? << Click Here >> for more details...
what are pseudocolumns?
- 4 Answers
- 10900 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / deva
pseudocolumns are the columns which are created by itself
when the table is created. The examples of the
pseudocolumns are rownum, rowid, currval, nextval and the
level
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / niranjan dhungia
psedocolumns are the columns which can not be manipulated.
psedocoluns are only retrive. Examples are rowid,nextval etc
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sohini
Pseudocolumns are not actual columns in a table but they
behave like columns. For example, you can select values
from a pseudocolumn. However, you cannot insert into,
update, or delete from a pseudocolumn. Also, pseudocolumns
are allowed in SQL statements, but not in procedural
statements. PL/SQL recognizes the following SQL
pseudocolumns, which return specific data items: CURRVAL,
LEVEL, NEXTVAL, ROWID, and ROWNUM.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / soujanya
A pseudocolumn behaves like a table column, but is not
actually stored in the table. You can select from
pseudocolumns, but you cannot insert, update, or delete
their values.
| Is This Answer Correct ? | 1 Yes | 0 No |
How to create a new tablespace in oracle?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
what is Single Byte Overhead...?
How to enter a new row into a table interactively?
how to delete all duplicate records from a table using subquery?
what is the scenario where you take the database to NoArchivelog mode?
What is a sub query? What are its various types?
How to best split csv strings in oracle 9i?
what is the difference between rollback & commit? can a foreign key has null value?
How to rename an existing table?
What are the most common interview questions on ETL Testing for experience?
What is meant by raw datatype?
Oracle General 
