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 |
What do you mean by a database transaction & what all tcl statements are available in oracle?
Explain temporal data types in oracle
What is the difference between postgresql and oracle?
how to use sequence and what use of sequence cache
How to get execution statistics reports on query statements?
What does a Control file Contain ?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
How to check the oracle tns settings?
Use of an integrity constraint is better to validate data. Explain
How to define a specific record type?
What are the oracle differences between nvl and coalesce
List the parts of a database trigger.