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 has
given you this table to retrieve exactly one row whenever required.
as Select 12 * 12 + 3; would certainly give you error. You can also give : -
Select 12 * 12 + 3 from emp but it would provide 14 rows instead of just one
row having results as :
147
147
147
147
147
147
147
147
147
147
147
147
147
147
14 rows selected
-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 are just goofs.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vikas Khanna
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).