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.

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

What does the sign mean in sql?

0 Answers  

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

What is normalization ?

9 Answers   BirlaSoft, CTS, HCL,

What is the maximum database size for sql express?

0 Answers  

Can a table have no primary key?

0 Answers  

if table named a is there and 4 records are there then how to swap (1 and 3) and (2 and 4) records at a time

1 Answers  

Is null operator in sql?

0 Answers  

How many tables can a sql database have?

0 Answers  

Why is pl sql needed?

0 Answers  

Write the command to remove all players named sachin from the players table.

0 Answers  

How do you create an update query?

0 Answers