这个是我平常用来批量删除数据,每500条数据提交一次。 declare cnt number(10):=0. i number(10). begin 0select count(*) into cnt from ep_arrearage_bak where to_char(df_date, mm )= 01 .
for i in 1..trunc(cnt/500) 1 loop 0delete from ep_arrearage_bak where to_char(df_date, mm )= 01 and rownum<=500. commit. end loop. end. |