Re: Parse SQL-statement in SQL-Plus

Giganews Newsgroups
Subject: Re: Parse SQL-statement in SQL-Plus
Posted by:  Sybrand Bakker (gooiditw…
Date: Sat, 11 Dec 2004

On 11 Dec 2004 03:43:11 -0800, ohahaa… (Ole Hansen)

>I use SQL-Plus. How can i parse the entire file, before i execute it,
>so that i can find the all the errors ???

Basically you can't.
Apparently you are performing syntax checks on a database with
production data. This is precisely why development databases and user
acceptance databases were invented: scripts should be error free
before they hit production, and they should be written, not hacked
Also it looks like your scripts doesn't have any error handling.
Regrettably, this is very common nowadays, and it also something never
should be done in a production environment.

As a work-around you could load your script in Toad, and hit Ctrl-F9
for every individual statement, and correct your typo's without doing

Sybrand Bakker, Senior Oracle DBA


In response to

Parse SQL-statement in SQL-Plus posted by Ole Hansen on 11 Dec 2004