Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: What is "dual"?
as already noted, table DUAL does exist. It's a mechanism used to satisfy
ANSI standard SQL which says "select SOMETHING from SOMEWHERE"...
<chriss_at_enteract.com> wrote in message news:93qnhc$873$1_at_nnrp1.deja.com...
> I am learning PL/SQL and have looked through two books, google
> searched, and 10 pages of DEJA and haven't found a good explanation...
>
> My book gives the example:
> SELECT 'COLUMBUS'
> INTO v_city
> FROM dual;
>
> There is no "dual" table though, so I'm curious just what this is. I
> would think it would be "FROM zipcode" which is the table that contains
> the city information.
>
> Insight appreciated. Thanks!
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Sat Jan 13 2001 - 17:33:23 CST