Interested to Buy Any Domain ? << Click Here >> for more details...
what are pseudocolumns?
- 4 Answers
- 10746 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 |
Explain what does a control file contain?
What is a sub query and what are the different types of subqueries?
How to use an explicit cursor without open statements?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to use "while" statements in oracle?
sql query to get zero records from a table
What is the difference between PFILE and SPFILE in Oracle?
what are stored procedures?
How can I combine multiple rows into a comma-delimited list in oracle?
What to do if the startbd.bat failed to start the xe instance?
What is an oracle wallet?
What is the use of file param in imp command?
Oracle General 
