Re: conditional statements

[Brian]

I know you can do this:
CREATE TABLE IF NOT EXISTS TEST1(ID NUMBER,NAME VARCHAR(8));
or
DROP TABLE TEST1 IF EXISTS;


-Brian

[Igal]

hi Brian,

yes, I am familiar with these constructs, but I want to do one "if" test and perform multiple actions, for example creating multiple tables and indexes.

any ideas?

thanks,

Igal