Re: FROM DUAL?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 25 Mar 2000 13:39:04 -0500
Message-ID: <us1qdsgmi8ajbvfncrr8j8ijmmk2kta551@4ax.com>

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 Received on Sat Mar 25 2000 - 12:39:04 CST