Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: what is dual?
what is dummy?
what is cathar heresy?
what is google IPO?
On 30 May 2002 at 13:18, Lon White wrote:
> Wow, google is definately a verbose tool. However, Eric might be more
> interested in the following: "DUAL is a table automatically created by
> Oracle along with the data dictionary. DUAL is in the schema of the user
> SYS, but is accessible by the name DUAL to all users. It has one column,
> DUMMY, defined to be VARCHAR2(1), and contains one row with a value ’X’.
> Selecting from the DUAL table is useful for computing a constant expression
> with the SELECT statement. Because DUAL has only one row, the constant is
> returned only once. Alternatively, you can select a constant, pseudocolumn,
> or expression from any table, but the value will be returned as many times
> as there are rows in the table." As quoted by Oracle.
>
> Have Fun!
> Lon
>
> Stephane Faroult wrote:
>
> > "Eric D. Pierce" wrote:
> > >
> > > begin
> > > hallo
> > > what is dual?
> > > exit
> > >
> >
> > Quote :
> >
> > Dualism is a time-honored philosophical position which is exemplified
> > by:
...
> >
> > (more of it at
> > http://www.artsci.wustl.edu/~philos/MindDict/dualism.html).
> >
> > There is also, of course, (ahahaha, how could I forget it) Spinoza's
> > dual-aspect theory in which the unitary substance God is expressed in
> > the distinct modes of the mental and the physical.
...
-- 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).Received on Thu May 30 2002 - 23:58:21 CDT
![]() |
![]() |