Ed Prochak wrote:
>
> In article <E4p64.3626$PV6.376554_at_news4.usenetserver.com>,
> "Wm. G. Urquhart" <william_at_devnet-uk.net> wrote:
> > I would like to include the logic in my script to drop a table (for
> example)
> > if it already exists. How do I do this.
> >
> > William.
> >
> > P.S. I did say that it was stupid.
> >
>
> Just put it in the same SQL script like this:
>
> drop table friends;
> create table friends
> (Name VARCHAR2(25) not null,
> Age NUMBER,
> birthdate DATE);
> insert into friends values
> ('BART SARJEANT',
> 22,
> TO_DATE('12-MAY-1946','DD-MON-YYYY') );
>
> and START it (START file.sql).
>
> BTW there are no stupid questions, only stupid answers.
You are right ! But are you joking ? Otherwise think to
your answer :-)
Received on Tue Dec 21 1999 - 18:09:34 CST
