Accessing Dual Table

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?

Questions by shanthiavari

Showing Answers 1 - 3 of 3 Answers


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.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions