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 -> Conditional Table Creation

Conditional Table Creation

From: <mbarbieri_at_atrco.com>
Date: 1997/09/26
Message-ID: <875288611.8851@dejanews.com>#1/1

In Transact SQL, I can conditionally create tables using the following script:

if object_id('footable') is null

        create table footable ( a int, b int null ) else

        alter table footable add b int null go

Is there any way in Oracle to use conditional statements to perform different actions under different circumstances?

Mark Barbieri
mbarbieri_at_atrco.com

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet
Received on Fri Sep 26 1997 - 00:00:00 CDT

Original text of this message

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