Re: Commit 1000 at a time, thats what I ended up doing

2003-07-09 Thread MaryAnn Atkinson
IF you are looking to break up the update into more 'manageable' pieces, here is a thought... UPDATE EMP2 SET GENDER = 'F' WHERE GENDER = ' ' AND ROWNUM = 100; Yes, that was exactly my objective, to update a large number of records and commit them 1000 at a time. Here is what I did:

Re: Commit 1000 at a time, thats what I ended up doing

2003-07-09 Thread Mark Richard
: Sent by: Subject: Re: Commit 1000 at a time, thats what I ended up doing [EMAIL PROTECTED