Wht is Dual Table in Oracle?

 Posted by Niladri.Biswas on 4/29/2013 | Category: Oracle Interview questions | Views: 3608 | Points: 40
Answer:

It is a dummy table in Oracle with one row and one Varchar2 column whose length is 1.
We can ask for any dummy values from dual as shown under

SQL> Select 1, SysDate From dual;

1 SYSDATE
---------- ---------
1 30-APR-13


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response