Dapi:

Be logical......
SQL Statement will be much faster than PL/SQL block execution...

to tell u...
In our DW prj....we delete about 10 million records a day....and previously the deletion was done using cursors....but it took long...i can say toooo long time to delete....

We then changed the script to wat i suggested in my post....
It was doing much faster than wat it did with Cursors....and mor ever with cursors & commit after 5000 records-snapshot too old errors.....

Abhay.