best way to delete large number of rows

[gdssmart]

Originally posted by abhaysk
Select count(*) into variable from table where ur condition

variable:=Round((variable)/(max records u think u can delete))+1

For cnt 1 to variable loop

delete with ur condition and with rownum < (max records u think u can delete)+1.

Loop.

Regards
Abhay.