Re: Table DUAL

From: Mike Hately <mike.hately_at_virgin.net>
Date: 2000/04/17
Message-ID: <8ddiep$rdv$1@lure.pipex.net>#1/1

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