1、通过存储过程方式
CREATE OR REPLACE procedure XXZY.p_test is i number; begin for i in 1..210000 loop INSERT INTO test_job VALUES(i,‘张三‘||to_char(i)); end LOOP; EXCEPTION WHEN OTHERS THEN DBMS_output.PUT_LINE(SQLERRM); end p_test; /
原文：http://www.cnblogs.com/Dylanblogs/p/4226837.html