oracle_五千万数据插入测试

--创建表 tab_a
--  create table tab_a (id int primary key not null,pid int);
--创建序列
/**
 create sequence seq_a 
   increment by 1
   start with 1
   nomaxvalue
   nocycle
   cache 20;
   **/
--创建存储过程
create or replace procedure pro_a_insert is
  i NUMBER(20);
begin
  for i In 1 .. 1000000 loop
    INSERT INTO tab_a
    VALUES
      (seq_a.nextval, i); IF mod
      (i, 100) = 0 THEN COMMIT;
  END IF;
END LOOP;
end pro_a_insert;
/
---调用


Procedure created.


SQL> CREATE OR REPLACE PROCEDURE CallHelloWorld1 (
  2    p_user  VARCHAR2
  3  ) AS
  4  BEGIN
  5    -- 调用存储过程的 存储过程
  6    HelloWorld1(p_user);
  7  END CallHelloWorld1;
  8  /


Procedure created.


执行
SQL> set serveroutput on
SQL> exec CallHelloWorld1( 'Tom' );
Hello Tom!


PL/SQL procedure successfully completed.



create or replace procedure pro_a_insert is
  i NUMBER(20);
begin
  for i In 1 .. 10000000 loop
    INSERT INTO tab_a
    VALUES
      (seq_a.nextval, i); IF mod
      (i, 100) = 0 THEN COMMIT;
  END IF;
END LOOP;
end pro_a_insert;


 每 1000万插入一次 ， 100  条提交一次