Originally posted by akwete
Commit after every 1000 row delete from table.

I am trying to delete from a table that has few thousands of rows. I will like to commit the delete after each 1000. How would I specify that in my delete statement?

I appreciate your help.

KC
with a cursor