oracle的批量删除数据表记录
对于数据库表中有海量的数据记录的情况。直接用delete命令删除的话，非常的慢。
以下是一个方法来批量删除数据记录：
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 /* 示例 ： begin delbigtab('sb_user', 'deleted = 1', '500'); end; */ WHILE 1 = 1 LOOP EXECUTE IMMEDIATE 'delete from ' || p_tablename || ' where ' || p_condition || ' and rownum <= :rn' 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;/