Answer Detail: RE: Dual table explain. Is any data internally storing...

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

September 09, 2005 09:36:14	#4
akebono	Member Since: Visitor Total Comments: N/A
RE: Dual table explain. Is any data internally storing...
The built-in function SYSDATE returns a DATE value containing the current date and time on your system. DUAL is built-in relation in Oracle which serves as a dummy relation to put in the FROM clause when nothing else is appropriate. For example, try "select 1+2 from dual;".So "select sysdate from EMP" won't generate the desired result.

Back To Question