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 h
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 r