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;