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

Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_sql.parse Question

Re: dbms_sql.parse Question

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 08 Apr 2006 10:15:40 -0700
Message-ID: <1144516534.616587@yasure.drizzle.com>


Galen Boyer wrote:
> On Fri, 7 Apr 2006, bob--nospam--_at_dynamicpsp.com wrote:

>> Please enlighten me, what is to be gained by being able to parse DDL
>> without executing it? 

>
> I could see a use for this. I'm developing a patch that has multiple
> modifications. I'm in my local testing area and am readying the file
> that is going to contain these alter statements. As I continue adding
> alters, I'd like to test the file for correctness without having to
> constantly back out the altering.

As Vladimir has stated ... move it to another database and it may still fail. Nothing is gained except a false sense of confidence.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Sat Apr 08 2006 - 12:15:40 CDT

Original text of this message

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