Re: Dynamice SQL in Oracle

On Fri, 13 May 2005 22:24:07 -0700, DA Morgan <damorgan_at_x.washington.edu> wrote:

>True but you are ignoring the point. There is NEVER a reason do create
>a table within a PL/SQL block. EVER!

 If an application is modifying its own schema in such a way, then yes, agreed, it's almost certainly a sign of poor design.

 But there do exist legitimate cases for use of "dynamic DDL" in upgrade scripts run in maintenance cycles, as one of several possible approaches to handling upgrading an application from some arbitrary older version to the current one.

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool