1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Psudo colums

Question Posted / raghuvnm


Psudo colums..

Answer / mathan r

It is a column that is not an actual column in the table.
eg USER, UID, SYSDATE, ROWNUM, ROWID, NULL, AND LEVEL.
rowid
versions_xid
versions_operation
versions_startscn
versions_endscn
sysdate
systimestamp
rownum
ora_rowscn
object_value
level
user

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

Why SQL Agent is used?

0 Answers   Abacus,

Why use view instead of a table?

0 Answers  

How to get the definition of a view out of the sql server?

0 Answers  

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,

What is bit data type? What's the information that can be stored inside a bit column?

0 Answers  




How we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,

What is unique key constraint?

0 Answers  

What does null mean?

0 Answers  

When cursors are useful?

0 Answers  

Can group by and orderby be used together?

0 Answers  

Define a cross join?

0 Answers  

What is the default fill factor value?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories