Answer Detail: RE: Dual table explain. Is any data internally storing in dual table. Lot of users are accessing select

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 17:30:44	#2
dimple	Member Since: Visitor Total Comments: N/A
RE: Dual table explain. Is any data internally storing in dual table. Lot of users are accessing select
hi, the sysdate is displayed irrespective of the table u r trying to select it from. The output is the same as that of using dual.

Back To Question