I would use a cursor loop with a commit because the database has several million records and it is running on rather antiquated hardware and I am concerned that I might run out of rollback space.