Re: New to Oracle: DDL in EXECUTE IMMEDIATE question

G Quesnel wrote:
> I am moving to a practice of doing most of my DDL in PL/SQL blocks
> using execute immediate. It allows me more flexibility, and the
> difference in performance is immaterial, as I am already in a
> maintenance window (application is shutdown).
> This is not part of the application.
> It is used for affecting schema modifications, during a new release of
> the application (once or twice a year).
> I have never notice any variation on the structure built this way,
> versus direct command in a SQL Plus session (typed or scripted) other
> then having more consistent structures in all my environments.
>
> My opinion.

OK, Thanks. So far that supports my assumption. Received on Tue Aug 29 2006 - 11:09:01 CDT