| |
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
|
| March 03, 2005 10:28:29 |
#1 |
| Raja |
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
|
| select * from dual;output will be:DUMMYXIt has a field called DUMMY with a value X.When you run select sysdate from emp;You will not get any error. You will get system in all rows (as number of rows in emp table). |
| |
Back To Question | |
