Re: Using IF statements in Oracle

Daniel Morgan wrote:
>
> You can not do DDL in PL/SQL except as dynamic SQL.
>
> But more imporantly ... you should not be attempting this. And even if
> you had some compelling reason to do it the commit work is meaningless
> other than to tell me that you learned SQL in some other product like
> SQL Server

Isn't changing the structure of a table as part of an application a very silly thing to do in any database system, whether it be it SQL Server, Oracle, Dbase, Jet, FM, or anything?

I suppose if he's trying to make an app which lets users design their own tables within a limited set of criteria, but still....

-- 
Tim - http://www.ucs.mun.ca/~tmarshal/
 ^o<  
 /#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^  "Want some?" - Ditto