Dual is a dummy table which oracle has provided to retrieve the values of
Environment Variables.
eg. Select user from dual;
Select sysdate from dual; and many other manipulations like
Select 12 * 12 + 3 from dual;
As the ANSI/SQL syntax requires FROM Clause so that's the reason Oracle
what is dummy?
On 24 Jul 2002 at 4:54, Vikas Khanna wrote:
Dual is a dummy table
...
-Original Message-
Sent: Wednesday, July 24, 2002 3:08 PM
To: Multiple recipients of list ORACLE-L
what is dual?
On 23 Jul 2002 at 10:53, Farnsworth, Dave wrote:
... The rest of us