Interested to Buy Any Domain ? << Click Here >> for more details...
what are pseudocolumns?
- 4 Answers
- 10964 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 |
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
How to build data dictionary view an new database?
WHAT IS ecc 6.0
What is the usage of save points in oracle database?
What is an Oracle view?
24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
Can a primary key contain more than one columns?
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
What is meant by joins?
How to restrict the duplicate records in table valuesets
Oracle General 
