desc MYTABLE
if it gives error message the table doesn't exist and you can create a table
of that name.
HTH
<shuiho_at_my-deja.com> wrote in message news:8l276n$3sn$1_at_nnrp1.deja.com...
> Hi everyone,
>
> I would like to do following:
>
> If the table MYTABLE does not exist then
> create table MYTABLE
> end if;
>
>
> How can I do this in Oracle SQLPLUS script ? Please help me.
> Thank you.
>
>
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jul 19 2000 - 00:00:00 CDT
