Re: Create a table only if the table doesn't exists

On Mon, 26 Jun 2006 16:10:20 -0400, "Mark C. Stock" <mcstockX_at_Xenquery .com> wrote:

>
>The only thing CREATE SCHEMA adds is what you might call 'DDL rollback' --
>still no conditional processing of DDL, just a different (and valuable) way
>of handling a single exception (rollback DDL and quit rather than just
>quit).
>
>PL/SQL provides conditional processing of DDL (i.e. exception handling), the
>SQL language does not, and the SQL*Plus tool does not.
>
>If conditional processing of DDL is required, you need a procedural language
>to manage the multiple DDL statements (which may or may not include CREATE
>SCHEMA).
>
>Real world, Daniel -- not all target systems are pristeen and run by
>conformant DBAs (and most of us don't have the power to throw non-conformant
>DBAs into the fireswamp, so don't suggest that option). Conditional DDL is
>actually sometimes required.

Mark, please don't be so ridiculous. Have you ever consulted catalaog.sql? Do you really want to turn that in 'conditional DDL'? Come on, get real.
Databases are *designed*, Mark!!!! If you don't know the meaning of that word, please look it up in a dictionary, or search a different profession!

--
Sybrand Bakker, Senior Oracle DBA