Re: Commit question in SQL*PLUS

in sqlplus you can do

whenever sqlerror exit 1

it exists everything when encounters an sql error

abc_at_iom.com wrote:

> 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 - 18:02:16 CDT