Re: Commit question in SQL*PLUS

On Thu, 15 Aug 2002 22:53:33 GMT, abc_at_iom.com wrote:

You could write a PL/SQL program. Also, in SQLPLUS there is a WHENEVER construct that you can employ that causes the script to end whenever and SQL error or IIRC any error occurs. Consult SQLPLUS User guide.

>New to Oracle, here.
>
>If I enter a batch of commands in SQL*PLUS, I want to have them all
>execute if the script is ok, or NONE executed if there's an error.
>Right now it looks like only the non-error lines of the script get
>executed. I'm looking for All-or-none.
>
>Thanks.
>
Received on Thu Aug 15 2002 - 20:04:57 CDT