Re: Conditional Table Creation

To conditionally create tables in Oracle use PL/SQL. Based on the example you use you will have no trouble picking up the syntax of PL/SQL. Jerry

mbarbieri_at_atrco.com wrote:
>
> 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 Sat Sep 27 1997 - 00:00:00 CDT