Interested to Buy Any Domain ? << Click Here >> for more details...
What is pseudo column ?
- 6 Answers
- 30490 Views
- ABB, I also Faced
- E-Mail Answers
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 are the types of keys?
What is sequence in sql?
Why does sql need a server?
What is the use of sql trace?
Why do we need unique key in a table?
what is pragma ?
What is difference between Procedures and Functions ?
Define tables and fields in a database
Why we use stored procedure instead of query?
Can we commit in trigger?
What is column?
suppose we have values like 1 5 7 in a colum.Now we want numbers like(2 3 4 6) that exists between 1 5 7.How can we do this using sql query??
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
