Re: SQL Command?

From: Al Ruiz <arruiz_at_flash.net>
Date: Wed, 28 Apr 1999 01:21:48 GMT
Message-ID: <3726642A.39923C7C@flash.net>

If you use PL/SQL you can create a loop (e.g.)

Loop
.
.
insert into .....
commit

.
.
.

end loop

Al

Patrick Suppes wrote:

> The short answer is NO, you cannot commit after every insert in
> a sql statement. Autocommit occurs between statements,
> as does the commits described by Mr. Fredericks.
>
> Patrick Suppes
> psuppes_at_lucent.com
>
> NetScans wrote:
>
> > Hope someone can help me. Is there any way to commit after every insert
> > and not at the end of the sql statement? I know in SQL+ there is "set
> > auto off" is there a command in SQL?
> >
> > Thanks,
> > Moises
Received on Tue Apr 27 1999 - 20:21:48 CDT