| |
GeekInterview.com > Interview Questions > Oracle > Database Administration
| Print | |
Question: Accessing Dual Table
Answer: Explain Dual table. Is any data internally stored in dual table. Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; what error will we get. Why? |
| August 08, 2008 14:09:21 |
#1 |
| abdulraheem_ar |
Member Since: August 2008 Total Comments: 2 |
RE: Accessing Dual Table
|
Dual is a system owned table created during database creation.
Dual table consist of a single column and a single row with value x
We will not get any error if we execute select sysdate from scott.emp
Â
Instead sysdate will be treated as a psudo column and displays the value for all the rows retrieved. |
| |
Back To Question | |
