what are pseudocolumns?
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 |
Youre getting high busy buffer waits - how can you find whats causing it?
what is RAID technology?which is better RAID 0+1 OR RAID 5?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?
Can group functions be used in the order by clause in oracle?
What is literal?
What is a proxy class?
What do you mean by merge in oracle and how can you merge two tables?
Explain an index segment?
What is the difference between RBBMS & DBMS?
What are set operators?
How view is different from a table?