CREATE OR REPLACE PROCEDURE p_maintendata
AS
v_rowcount NUMBER(20);
BEGIN
LOOP
DELETE FROM tInnoCallStatInfo
WHERE STATISTICSTARTTIME < SYSDATE - 3
AND ROWNUM <= 2000;
v_rowcount := SQL%ROWCOUNT;
COMMIT;
EXIT WHEN v_rowcount = 0;
END LOOP;
EXCEPTION
WHEN OTHERS THEN
ROLLBACK;
RETURN;
END p_maintendata;
/
huawei--循环,SQL%ROWCOUNT为0控制结束
最新推荐文章于 2024-04-22 10:01:09 发布