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
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is the recommended interval at which to run statspack snapshots, and why?
What is catalog in Oracle?
How to call a sub procedure?
How to create tables for odbc connection testing?
What is a dynamic performance view in oracle?
What are transaction isolation levels supported by oracle?
How to select an oracle system id (sid)?
ABOUT IDENTITY?
What is a nvl function? How can it be used?
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
How to export your own schema?
What is the use of file param in imp command?
What is the difference between substr & instr functions?