oracle存储过程插入百万数据

创建表

create  table sjbjsource1(  
        ID    NUMBER(10) NOT NULL PRIMARY KEY,  
        NAME VARCHAR(50),
        time1  timestamp
    ); 

创建存储过程

create or replace procedure insert_sjbj is

i number;
begin
i:=0;
loop
  i:=i+1;
  if i>1000000 then
    exit;
  end if;
  insert into sjbjsource1(id,name,time1) values(i,i,sysdate);
 
end loop;

end insert_sjbj;

为表创建自增字段

 CREATE SEQUENCE sjbjs_sequence  
    INCREMENT BY 1  
    START WITH 1  
    NOMAXVALUE  
    NOCYCLE  
    NOCACHE;
    
    
    CREATE TRIGGER "sjbjs_trigger" BEFORE  
    INSERT ON sjbjsource1 FOR EACH ROW WHEN(new.id is null)  
    BEGIN  
    select sjbjs_sequence.nextval into:new.id from dual;  
    end;