Thread: What is the syntax turn off auto commit?

The Subject says its all.

To speed up a bulk of  INSERTs, I need to turn-off the auto commit 1st.
Then
at the end of INSERTs, issue COMMIT;
What is the syntax to turn off the auto commit? Thank you!

--Raymond

On Wed, 18 Jul 2001, Raymond Chui wrote:

>
>
> The Subject says its all.
>
> To speed up a bulk of  INSERTs, I need to turn-off the auto commit 1st.
> Then
> at the end of INSERTs, issue COMMIT;
> What is the syntax to turn off the auto commit? Thank you!

Put them in an explicit transaction block
begin
 insert ...
 insert ...
commit;