Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Conditional Table Creation
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 UsenetReceived on Fri Sep 26 1997 - 00:00:00 CDT