Re: FROM DUAL?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 27 Mar 2000 21:00:42 +0800
Message-ID: <38DF5B7A.37BE@yahoo.com>

Thomas Kyte wrote:
>
> A copy of this was sent to "Alexander Celle T." <acelle_at_puc.cl>
> (if that email address didn't require changing)
> On Sat, 25 Mar 2000 14:22:03 -0400, you wrote:
>
> >Anyone know a good source of examples, tutorials or any other material
> >that may help me understand how it works. Also, is there any SQL
> >standard for FROM DUAL?, is it possible to transform it into standard
> >SQL (by creating tables, etc.).
> >
> >Any help is appreciated.
> >
> >P.D. is there any command like FROM DUAL for DB2?
>
> DUAL is just a table with 1 row and (usually) 1 column. Its a real, physical
> table.
>
> You can create DUAL in any SQL database.
>
> --
> http://osi.oracle.com/~tkyte/
>
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries Reston, VA USA
>
> Opinions are mine and do not necessarily reflect those of Oracle Corporation

Hello Thomas,

Doesn't DUAL become a "funny" table in 8.1-something.. that is, based on an X$ equivalent ?

--

---

Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse Received on Mon Mar 27 2000 - 07:00:42 CST