SM341700删除大数据

BEGIN
  LOOP
    DELETE 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;