Re: Table DUAL

All uses of dual assume that it has one row only. But it is possible to insert multiple rows into dual, so when you're fooling around with it keep that in mind. If you end up with multiple rows in dual, delete all but one.

Van

Mike Hately <mike.hately_at_virgin.net> wrote in message news:8ddiep$rdv$1_at_lure.pipex.net...
> DUAL is used to preserve syntax in SQL statements which have no target
> table.
> With that in mind you can use it to run commands which would otherwise be
> invalid.
>
> select sysdate from dual;
>
> select :b1 + :b2 from dual;
>
> select upper ('&enter_value') from dual;
>
> etc.
>
> regards
>
> Mike Hately
>
> <icemelid_at_my-deja.com> wrote in message
 news:8dahov$ruo$1_at_nnrp1.deja.com...
> >
> >
> > Hi Sir
> >
> > I know some simple uses of the DUAL table, like
> >
> > select 1+1 from dual
> >
> > Do you know some other uses about this table, if it
> > is a table.
> > Or could you tell me where to find some extra information.
> >
> > Thanks in advance.
> >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Mon Apr 17 2000 - 00:00:00 CDT