Xref: alice comp.databases.oracle.server:72686
Path: alice!news-feed.fnsi.net!news.idt.net!newsfeed.mathworks.com!cam-news-hub1.bbnplanet.com!news.gtei.net!newscon02!prodigy.com!not-for-mail
From: "Niraj Mehta" <amrnirj@prodigy.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: PL/SQL statement
Date: Thu, 4 Nov 1999 14:40:33 -0800
Organization: Prodigy Internet http://www.prodigy.com
Lines: 33
Message-ID: <7vs9e3$20no$1@newssvr04-int.news.prodigy.com>
References: <7vn50u$o3g$1@sloth.swcp.com>
X-Trace: newssvr04-int.news.prodigy.com 941730051 4690017 209.253.157.14 (4 Nov 1999 15:40:51 GMT)
X-Complaints-To: abuse@prodigy.net
NNTP-Posting-Date: 4 Nov 1999 15:40:51 GMT
X-Newsreader:  Microsoft Outlook Express 5.00.2615.200
X-MSMail-Priority:  Normal
X-Priority:  3
X-MimeOLE:  Produced By Microsoft MimeOLE V5.00.2615.200

Sure. You could do this by writing a Select statement in your code. This
could be something like the following:

SELECT     count(*)
INTO          <variable>
FROM        all_tables
WHERE    table_name = '<table_name>'

After this, you could if this variable shows the value of 0 (meaning the
table does not exist), go to the create table statement. If it shows 1
(meaning the table exists), go to the end of the code.

This must solve your problem.



<elufker@llama.swcp.com> wrote in message
news:7vn50u$o3g$1@sloth.swcp.com...
> Hi All;
>
>
> Does anyone have any example code that would check to see if a table
> exsists, and if not skip to the create table statement. If the table does
> exsist, then just skip to the end.
>
>
> Thanks in advance for any help here
> Eddie Lufker
>
>
>