SM341700删除大数据

BEGINLOOPDELETE FROM sm_sc_zsbcrwmx_tb WHERE rownum <= 10000 AND where to_char(createtime,'yyyymm')=201806;EXIT WHEN SQL%ROWCOUNT = 0;COMMIT;DBMS_LOCK.SLEEP(2);  -- 暂停2秒END LOOP;
END;GRANT EXECUTE ON DBMS_LOCK TO SM149;