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
Refer to the PL/SQL reference manuals for procedural
type stuff. You will need to also look into the dbms_sql
package supplied with Oracle to perform ddl statements
in the PL/SQL environment.
TRG
Received on Sat Sep 27 1997 - 00:00:00 CDT
