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 |
What is an intersect?
..........refers to the disk mirroring
If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?
select 1,col1,col2 from table1. output?
What is sql and db2?
How to get second highest salary from a table
How can the performance of a trigger be improved?
What is a data manipulation language?
What is the difference between cluster and non-cluster index?
i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id. pls give me answer. i want urgent
How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }
what are the differences between binary and varbinary? : Sql dba