17,377
社区成员
发帖
与我相关
我的任务
分享
declare cursor ID_KEY_CURSOR is
SELECT t.senddate senddate from ICDRPT.SUM_PROVINCE_BUSINESS_H15 t where substr(t.senddate,1,8) < '20190101';
begin
for V_TO_DEL in ID_KEY_CURSOR loop
DELETE FROM ICDRPT.SUM_PROVINCE_BUSINESS_H15
WHERE ICDRPT.SUM_PROVINCE_BUSINESS_H15.SENDDATE = V_TO_DEL.senddate;
if mod(ID_KEY_CURSOR%Rowcount, 5000) = 0
then commit;
end if;
end loop;
commit;
end;