RE: Myers-Briggs - Too many off topic topics! MUST READ CAREFULLY

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: eric_d_pierce_at_pacbell.net

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: ListGuru_at_fatcity.com (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: vkhanna_at_quark.co.in

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: ListGuru_at_fatcity.com (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).