Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Using IF statements in Oracle
Tim Marshall wrote:
>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....
>
>
You are correct. If the point is to provide user configurable columns
... this is still a poor implementation. It can easily be done with
three or so static columns and an additional VARCHAR-type column holding
a pseudo column_name.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Wed Sep 17 2003 - 18:26:02 CDT