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

July 07, 2006 15:59:00	#6
P.Sathe	Member Since: Visitor Total Comments: N/A
RE: Dual table explain. Is any data internally storing...
You can issue "sysdate" from any table, but the result will be as many rows as your table , that you used. The whole idea behind using "DUAL" table is to meet the the criteria as defined by RDBMS , that you have to use "Select.. from" syntax to get the values from column.

Back To Question