Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
How can I tell if sql is running?
How do I count rows in sql query?
How to make a copy values from one column to another in sql?
How is pl sql different from sql?
Is join same as left join?
Why are indexes and views important to an organization?
What is pl sql script?
Why do we use triggers?
What are the types of records?
How much does sql cost?
What is a dynamic query?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What are sql triggers used for?
What is t sql used for?
How many types of normalization are there?
