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.
Received on Tue Aug 29 2006 - 10:57:52 CDT
