What is pseudo column ?
Answers were Sorted based on User's Feedback
Answer / senthilnathan
A pseudo column is an item of data which does not belong in
any particular table but which can be treated as if it did.
Any SELECT list of columns can include these pseudo
columns.
SYSDATE current date and time
ROWNUM sequence number assigned to retrieved rows
ROWID unique identifier for a row
UID number associated with a user
USER userid of current user
Is This Answer Correct ? | 43 Yes | 12 No |
Answer / mail2sentha
pseudo column is a act as an database table column,but its
not a actual column in a table,we can fetch value from a
pseudo column.
ex.
user,usid,rownum,rowid,level,nextval,curval,sysdate
Is This Answer Correct ? | 29 Yes | 6 No |
Answer / nazeer
pseudo column act as database table column, but not actually the exact column in the table....we can fetch values from the pseudo column....
The Columns are..
user,
userid,
rownum,
rowid,
level,
nextval,
curval,
sysdate.......
Is This Answer Correct ? | 14 Yes | 2 No |
Answer / nagarjuna reddy
A pseudo column is a column but it is not physically existed
in the table.if we want to use these column by specifying
externally in select statement for projection or selection.
but we can't insert,delete and update pseudo columns.
some of pseudo columns are
1 ROWID
2 ROWNUM
3 LEVEL
4 CURRVAL
5 MEXTVAL
etc...
Is This Answer Correct ? | 9 Yes | 3 No |
Answer / sudhir pradhan
pseudo column is false state. pseudo column behave like a table column, but it is actually not stored in table.
Is This Answer Correct ? | 0 Yes | 1 No |
How to Execute a Package in PL/SQL.?
What are different types of statements supported by sql?
What are crud methods?
What is cursor in pl sql?
which will default fire first statement level trigger or row level trigger
2 Answers Cap Gemini, Data Vision,
How do you determine the current isolation level? : Transact sql
Can we call procedure in select statement?
What does count (*) mean in sql?
What is dense_rank in sql?
What is form and report?
Why stored procedure is faster than query?
How to access the current value and next value from a sequence?