CREATE OR REPLACE PROCEDURE MESDBA.DEL_TABLEDATA
AS
CURSOR DEL_INFOS IS SELECT ROWID FROM AT_AS_SM_FAULT_CODE WHERE CREATION_TIME <= SYSDATE -200 AND ROWNUM<=10000;
BEGIN
FOR DEL_INFO IN DEL_INFOS LOOP
DELETE FROM AT_AS_SM_FAULT_CODE WHERE ROWID=DEL_INFO.ROWID;
END LOOP;
COMMIT ;
Exception
When others then
Rollback;
END;
oracle快速删除表的数据
最新推荐文章于 2024-07-17 13:58:11 发布