Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

simple commit after update of so many records

Ratzie
Super Advisor

simple commit after update of so many records

I have run into a problem with data in a table.

I am trying to set a column to NULL where column =' ' (space)

I can run on some data, but others I fill up the roll backs.

Can I add a statement that would commit after every 500 updates?

update table
set COLUMN1 = NULL
where COLUMN1=' ';

1 REPLY
Michal Kapalka (mikap)
Honored Contributor

Re: simple commit after update of so many records

hi,

check this discussion :

"commit after n rows while update"

http://forums.oracle.com/forums/thread.jspa?messageID=3652792

mikap