----oracle插入60000条数据 For in loop
begin
for i in 11100000 .. 11160002 loop
insert into TT_TCAS_HUBPBS_HUB_EMP_INFO
(HUB_PBS_EMP_ID,
EMP_NO,
WORK_TIME,
JOB_SEQ,
GROUP_CODE,
WORK_DATE,
DEPT_CODE,
AREA_CODE,
EMP_NAME,
PERSON_TYPE,
CREATED_EMP_CODE,
CREATED_TM,
MODIFIED_EMP_CODE,
MODIFIED_TM,
JOB_SEQ_CODE,
PERSON_TYPE_CODE)
values
(i,
to_char(i),
'8',
'0.5',
'group_name_' || i,
date '2015-04-01',
'025W',
'025Y',
i,
'全日制员工',
'212113',
sysdate,
'212113',
sysdate,
'z' || i,
'A');
end loop;
commit;
end;
--------------------------------------------------------------------------------------------------------------
------插入双变量的表------------------------------------------------------------------------------------------------
CREATE TABLE t_tab(num1 INT,num2 INT);
BEGIN
FOR i IN 1..100 LOOP
FOR j IN 1..5 LOOP
INSERT INTO t_tab VALUES(i,j);
END LOOP;
END LOOP;
COMMIT;
END;
------------------插入日期的变量表----------------------------------------------
- BEGIN
- EXECUTE IMMEDIATE 'truncate table etl_date';
- for v_date in 20091001 .. 20091021 LOOP
- INSERT INTO etl_date
- (date_char, date_date)
- SELECT v_date, to_date(v_date, 'YYYY-MM-DD') FROM dual;
- END LOOP;
- COMMIT;
- END;
--------------------------------插入10000条数据---------------------
SQL>
SQL> begin
2 for i in 1 .. 100000
3 loop
4 insert into t values ( i, 'x' );
5 end loop;
6 commit;
7 end;
8 /
PL/SQL procedure successfully completed.
SQL>
SQL> select count(*) from t;
COUNT(*)
----------
100000
--排班小组信息
begin
for i in 1000000..1060000 loop
insert into TT_TCAS_HUBPBS_HUB_GROUP_INFO
values(i,
'731Y',
'734W',
'group_code_' || i,
'group_name_' || i,
'212113', sysdate,
'212113', sysdate, 0);
end loop;
commit;
end;
--中转场系数--
begin
for i in 1000000..1060000 loop
insert into TM_TCAS_HUB_COEFFICIENT
values(seq_tcas_hub.nextval,
'石柱' || i,
'734W',
'1' ,
date'2020-01-01',
'石柱',
'212113',sysdate,
'212113',sysdate,
'0',
'0.0001');
end loop;
commit;
end;
--小组处理量
begin
for i in 1000000..1060000 loop
insert into TT_TCAS_HUB_GROUP_PROCESS_QTY
values(i,
date'2015-08-29',
'731Y',
'group_code_' || i,
'group_name_' || i,
i,
'业务高峰期',
'212113',sysdate,
'212113',sysdate,
'734W'
);
end loop;
commit;
end;
--中转场处理量
begin
for i in 11000000..11060000 loop
insert into TT_TCAS_HUB_PROCESS_QTY
values(i,
date'2016-01-01',
'010Y',
'010W',
'北京顺义中转场',
i,
'中转场处理量'||i,
'212113',sysdate,
'212113',sysdate,
'0'
);
end loop;
commit;
end;
--排班汇总信息
begin
for i in 1000000..1060000 loop
insert into TT_TCAS_HUBPBS_HUB_EMP_INFO
values(i,
i,
'8',
'10',
'group_name_' || i,
date'2020-01-01',
'734W',
'731Y',
i,
'全日制员工',
'在职',
'212113',sysdate,
'212113',sysdate,
'z' || i
);
end loop;
commit;
end;