Re: What is "dual"?

From: ez <fake_at_fake.com>
Date: Sat, 13 Jan 2001 23:29:22 -0000
Message-ID: <vw586.175693$eT4.13583518@nnrp3.clara.net>

yes, there is a dual table owned by sys. desc sys.dual;
it has only only column, datatype varchar2

<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:29:22 CST