Interested to Buy Any Domain ? << Click Here >> for more details...
What is pseudo column ?
- 6 Answers
- 30572 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 |
Is sql a programming?
pl/sql testing means what ...... explain process how to find pl/sql bugs
Main diff between varray and nested tablea
What is the clause we need to add in function body to return variable?
what is a sub query?how will you calculate working days in a month using sub query?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What is the purpose of design view?
What is %type in pl sql?
Is sql better than access?
What is sql trigger example?
Why having clause is used in sql?
How the execution will be done in exceptions?
-
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)
