Oracle 存储过程脚本 插入十万条记录

 create table TEE16

(
  DOUBLE1  NUMBER(10,4) default 0 not null,DOUBLE2  NUMBER(10,4) default 0 not null,
  DOUBLE3  NUMBER(10,4) default 0 not null,DOUBLE4  NUMBER(10,4) default 0 not null,
  DOUBLE5  NUMBER(10,4) default 0 not null,DOUBLE6  NUMBER(10,4) default 0 not null,
  DOUBLE7  NUMBER(10,4) default 0 not null,DOUBLE8  NUMBER(10,4) default 0 not null,
  DOUBLE9  NUMBER(10,4) default 0 not null,DOUBLE10 NUMBER(10,4) default 0 not null,
  DOUBLE11 NUMBER(10,4) default 0 not null,DOUBLE12 NUMBER(10,4) default 0 not null,
  DOUBLE13 NUMBER(10,4) default 0 not null,DOUBLE14 NUMBER(10,4) default 0 not null,
  DOUBLE15 NUMBER(10,4) default 0 not null,DOUBLE16 NUMBER(10,4) default 0 not null,
  DOUBLE17 NUMBER(10,4) default 0 not null,DOUBLE18 NUMBER(10,4) default 0 not null,
  DOUBLE19 NUMBER(10,4) default 0 not null,DOUBLE20 NUMBER(10,4) default 0 not null
)

-- Add comments to the table 
comment on table TEE16 is 'GRID大数据量测试';

-- Add comments to the columns 
comment on column TEE16.DOUBLE1 is '数据一';

comment on column TEE16.DOUBLE2 is '数据二';

comment on column TEE16.DOUBLE3 is '数据三';

comment on column TEE16.DOUBLE4 is '数据四';
comment on column TEE16.DOUBLE5 is '数据五';

comment on column TEE16.DOUBLE6 is '数据六';
comment on column TEE16.DOUBLE7 is '数据七';

comment on column TEE16.DOUBLE8 is '数据八';
comment on column TEE16.DOUBLE9 is '数据九';

comment on column TEE16.DOUBLE10 is '数据十';
comment on column TEE16.DOUBLE11 is '数据十一';

comment on column TEE16.DOUBLE12 is '数据十二';
comment on column TEE16.DOUBLE13 is '数据十三';

comment on column TEE16.DOUBLE14 is '数据十四';
comment on column TEE16.DOUBLE15 is '数据十五';

comment on column TEE16.DOUBLE16 is '数据十六';
comment on column TEE16.DOUBLE17 is '数据十七';

comment on column TEE16.DOUBLE18 is '数据十八';
comment on column TEE16.DOUBLE19 is '数据十九';

comment on column TEE16.DOUBLE20 is '数据二十';

-------------------------------------------------------
declare
count1 number(10):=1;

begin
    loop
      insert into iplat.tee16
        (
         double1,double2,double3,double4,double5,double6,double7,double8,double9,double10,
         double11,double12,double13,double14,double15,double16,double17,double18,double19,double20
        )
      values
        (
         count1,11111.1111,22222.2222,33333.3333,44444.4444,55555.5555,66666.6666,77777.7777,88888.8888,99999.9999,
         12345.1234,12222.1111,23333.2222,34444.3333,45555.4444,56666.5555,67777.6666,78888.7777,89999.8888,
         90000.9999    
        );
        count1 := count1+1;
       exit when count1>100000;
     end loop;
end;