熱門標簽：南通防封外呼系統運營商語音電話機器人缺點淮安自動外呼系統開發廣州市400電話辦理語音電話機器人營銷方案百變地圖標注地圖標注原件宜賓外呼系統廠家修改高德地圖標注寫一個循環刪除的過程。 create or replace procedure delBigTab(p_TableName in varchar2,p_Condition in varchar2,p_Count in varchar2) as pragma autonomous_transaction; n_delete number:=0; begin while 1=1 loop EXECUTE IMMEDIATE 'delete from '||p_TableName||' where '||p_Condition||' and rownum = :10000' USING p_Count; if SQL%NOTFOUND then exit; else n_delete:=n_delete + SQL%ROWCOUNT; end if; commit; end loop; commit; DBMS_OUTPUT.PUT_LINE('Finished!'); DBMS_OUTPUT.PUT_LINE('Totally '||to_char(n_delete)||' records deleted!'); end delBigTab; 調用： SQL> set timing on SQL> exec delBigTab('HS_DLF_DOWNLOG_HISTORY','NUMDLFLOGGUID 11100000','10000'); PL/SQL procedure successfully completed. Elapsed: 00:00:18.54 方法雖好，但我應用在一個億級數據庫時還是覺得慢得不行。就算刪一點點數據也覺得好象挺慢的。
