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
What is private procedure oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is procedure overloading in oracle?
What are the ansi data types supported in oracle?
How to use subqueries with the in operator using oracle?
How to write a query with a left outer join in oracle?
What are the tools for Oracle ?
How will you differentiate between varchar & varchar2?
How to use "for" statements in oracle?
How to connect ms access to oracle servers?
How to create an oracle database manually?
What is parameterized cursor in oracle?
Can multiple columns be used in group by in oracle?
What is a Garbage Collection? and what is full recursive Garbage collection?
What is system tablespace?