Interested to Buy Any Domain ? << Click Here >> for more details...
what are pseudocolumns?
- 4 Answers
- 10797 Views
- I also Faced
- E-Mail Answers
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 |
How to install oracle database 10g xe?
What is meant by joins?
What is a trigger oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How many memory layers are in the oracle shared pool?
Explain the use of inctype option in exp command.
How to do paging with oracle?
What is the use of aggregate functions in oracle?
What are the extensions used by oracle reports?
What is a dead lock in oracle?
how to find the second highest salary in a given table????
How to use "in out" parameter properly?
Oracle General 
