Interested to Buy Any Domain ? << Click Here >> for more details...
what are pseudocolumns?
- 4 Answers
- 10975 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 assign data of the deleted row to variables?
How to retrieve data from an cursor to a record?
Explain the use of grant option in imp command.
How remove data files before opening a database?
What do you mean by a database transaction & what all tcl statements are available in oracle?
Give syntax for SQL and ORACLE joins.
What is parameterized cursor in oracle?
What is an oracle user role?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Can you tell me how to add new column in existing views?how?How is possible?
What is a Synonym ?
What privilege is needed for a user to insert rows to tables in another schema?
Oracle General 
