Re: A simple (but stupid) question.

From: Ed Prochak <prochak_at_my-deja.com>
Date: Fri, 17 Dec 1999 18:00:43 GMT
Message-ID: <83dto8$2sh$1@nnrp1.deja.com>

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.

--
Ed Prochak
Magic Interface, Ltd.
ORACLE Development, conversions, training and support 440-498-3700 magic_at_interfacefamily.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 17 1999 - 12:00:43 CST