Committing after every 100 deletes/updates

From: Baswannappa, Shiva <SXBaswan_at_dcss.com>
Date: Fri, 25 Apr 2003 13:13:11 -0800
Message-ID: <F001.00589E27.20030425131311@fatcity.com>

Hi Gurus

Another TGIF question.

I am using 9iV2 on HP-UX R-11. my question is:

Is there a way to auto commit changes made to a table after every say 100 records or so? I am processing 1000s of records and want to make sure the changes are autocommitted. the changes are made in a procedure bundled in a package with several other procedures.

I thought I saw a statement similar to "delete from tab1 where col1='col1'.... commit

not sure

or may be definition of the table can be changed in such a way to commit periodically!!!

Thanks in advance for all the suggestion I get

Regards

Shiva
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Baswannappa, Shiva
  INET: SXBaswan_at_dcss.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Apr 25 2003 - 16:13:11 CDT