GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Tech FAQs  >  Oracle

 Print  |  
Question:  Can you explain what is DUAL table in oracle ?




July 07, 2007 09:38:54 #5
 lieni   Member Since: Visitor    Total Comments: N/A 
RE: Can you explain what is DUAL table in oracle ?
 
Sorry dual is not a dummy table. Dual really exists and also that it has exactly one row and one column isn't correct.

You can insert:

Insert into dual value 'Y'

Select sysdate from dual will then return two lines with the actual timestamp.
     

 

Back To Question