Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Create a table only if the table doesn't exists

Create a table only if the table doesn't exists

From: fred <r5tr_at_free.fr>
Date: Thu, 22 Jun 2006 18:35:42 +0200
Message-ID: <e7egsu$598$1@s1.news.oleane.net>


Hello,

I want to write a sql script that creates a table only if the table doesn't already exists (but if the table creation fails for another reason than "table already exists" I want to know about it). Is it possible to do that in sql only or is pl/sql needed ? If needed, how do you do that in pl/sql ?

Thanks a lot for your help.

Fred. Received on Thu Jun 22 2006 - 11:35:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US