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  >  Interview Questions  >  Oracle  >  Scenarios

 Print  |  
Question:  Dual table explain. Is any data internally storing 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



November 11, 2005 05:11:53 #5
 santhi   Member Since: Visitor    Total Comments: N/A 
RE: Dual table explain. Is any data internally storing...
 
We won’t get any error if we select sysdate from emp table.the system date will be displayed for each row of the emp table. but if will select sysdate from dual. asingle row in which system date will be displayed
     

 

Back To Question