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.

How do I view stored procedures?

0 Answers  

Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,

Define commit?

0 Answers  

what is myisam? : Sql dba

0 Answers  

What is clause in sql?

0 Answers  

How do I view tables in mysql?

0 Answers  

What is Overloading of procedures ?

4 Answers   Amdocs,

what is the difference between where clause and having clause? : Sql dba

0 Answers  

how to get second highest salary in SQL(as/4000

29 Answers   iGate,

What are the different types of tables in sql?

0 Answers  

Mention what does plv msg allows you to do?

0 Answers  

Why do we need cursor in pl sql?

0 Answers