What is pseudo column ?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / avinasm pradhan

6 Answers
30993 Views
ABB, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is pseudo column ?..

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

What is pseudo column ?..

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

What is pseudo column ?..

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

What is pseudo column ?..

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

What is pseudo column ?..

Answer / kiran

send me the answers

Is This Answer Correct ?

0 Yes

0 No

What is pseudo column ?..

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

Post New Answer