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

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

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.......

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...

Answer / kiran

send me the answers 

Answer / sudhir pradhan

pseudo column is false state. pseudo column behave like a table column, but it is actually not stored in table.

What is the most important ddl statements in sql are?

0 Answers  

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  

How to find only %th Highest Sal

6 Answers   Infogain, Symphony,

How do I count records in sql?

0 Answers  

What is a data manipulation language?

0 Answers  

What is partition in sql query?

0 Answers  

Which function is used to return remainder in a division operator in sql?

0 Answers  

What is mutating table error?

0 Answers  

What is interval partition?

0 Answers  

Can we interchange parameters in procedure while calling

1 Answers   TCS,

Does asenumerable execute the query?

0 Answers  

what is Complex index. how to create it?

2 Answers