Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Command?
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
Moises,
To commit after each insert statement,
do the following :-
set autocommit on
Thanks
Sai
Received on Wed Apr 14 1999 - 10:19:27 CDT
![]() |
![]() |