Wht is Dual Table in Oracle?

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

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 30-APR-13

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response