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: IF Exists SQL statement help

Re: IF Exists SQL statement help

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 23 Aug 2002 21:26:19 -0500
Message-ID: <uelcoes9g.fsf@hotpop.com>


On Fri, 23 Aug 2002, postbus_at_sybrandb.demon.nl wrote:

> The only need for it would occur when creating tables on-the-fly which
> is exactly what you should *NOT* do using Oracle.

This is certainly the statement for production code, but scripts that help one build and rebuild things for their own personal sandboxes could very easily want to do such existence checking.

Not every question has to be taken as though the end-result is going to be a production piece of SQL.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.
Received on Fri Aug 23 2002 - 21:26:19 CDT

Original text of this message

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