Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Create a table only if the table doesn't exists

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

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Mon, 26 Jun 2006 18:21:08 -0400
Message-ID: <F9idnVY72_xKwD3ZnZ2dnUVZ_tadnZ2d@comcast.com>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:3ii0a2pr3lak0pq0qhah1ag4ppq3e0slee_at_4ax.com...
: 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

whatever.

++ mcs Received on Mon Jun 26 2006 - 17:21:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US