Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to list all user accounts in oracle?
When do we use group by clause in a sql query?
Explain what are the different type of segments?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How to speed up webrick?
Explain the use of record length option in exp command.
What is a system tablespace?
What is an Oracle index?
How do you tell what your machine name is and what is its IP address?
Explain integrity constraint?
What is the difference between substr & instr functions?
What is a server parameter file in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What is truncate oracle?
What is the difference between "as" and "is" in an oracle stored procedure?
