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

Mark C. Stock wrote:
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:dafq92tac12l3vhip5amcsn5qu8is60pac_at_4ax.com...
> : On Sat, 24 Jun 2006 14:54:03 +0200, "Joseph Balsamo" <r5tr_at_free.fr>
> : wrote:
> :
> : >> Better but still a very bad idea. What is the business case for
> : >> implementing a known bad practice of creating tables with procedural
> : >> code?
> : >
> : >Just for my information, may I ask why it is a bad practice ?
> : >
> :
> : Databases happen to be designed. Adding tables on the fly is not a
> : proper design procedure.
> : You create your tables in a relational database management system.
> : How can any DBA guarantee consistency, when your program is treating
> : the database as a replacement for flat files, or as a replacement for
> : a garbage bin?
> :
> : --
> : Sybrand Bakker, Senior Oracle DBA
>
> Sybrand, have you guys every heard of installation scripts?
>
> ++ mcs

Yes and it is irrelevant. Have you heard of CREATE SCHEMA?

Running scripts != PL/SQL when it comes to DDL.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org