Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: What is "dual"?
Actually dual is SUPPOSED to have only one row but you should watch this. It's possible to put more than one row into the table which can lead to some interesting things.
Van
"ez" <fake_at_fake.com> wrote in message
news:vw586.175693$eT4.13583518_at_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 - 20:21:48 CST