Oracle Auto Commit during transaction.

Hi,

If I send an Update like this:

UPDATE MyTable SET Field1 = value WHERE Field2 = value2;

there is a way that Oracle make a commit every X records updated?

Note: this update can alter thousand of records at the same time.

Thank you. Received on Fri Mar 14 2008 - 15:23:34 CDT