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 03:22:06	#3
Ravi	Member Since: Visitor Total Comments: N/A
RE: Dual table explain. Is any data internally storing...
The output wont be same .Ideally dual has single row so when selecting sysydate you will get one row which is not the case in emp which has multiple row .

Back To Question