Answer Posted / 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 |
Post New Answer View All Answers
Who developed oracle & when?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How to connect ms access to oracle servers?
What is oracle host variable?
How to define an external table with a text file?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
How to commit the current transaction in oracle?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
How to define a cusotmer as a supplier in ORACLE R12
How to establish administrator authentication to the server?
What is the difference between view and materialized view in Oracle?
What is an oracle recycle bin?
How to resolve name conflicts between variables and columns?
Explain how you would restore a database using RMAN to Point in Time?