一、Test Windos方式 declare9 `: d5 {! I- o* I5 V
maxrecords constant int:=100000;
$ k2 P4 N0 G4 x+ g i int :=1;
/ a' j# h! q+ f' A8 F begin3 A I9 a# K: J2 C
for i in 1..maxrecords loop7 \0 s. e- H4 l0 r# }6 |% a, z
insert into test2
' A' z7 ^* j2 q( }1 H (id, name)
! {) _: {/ w1 ]7 [: O4 L, E5 M values
2 T9 D0 a7 d: Z8 G% v (test2_seq.nextval, to_char(9999+i));
- X$ O$ k2 R1 q( ~( d" ? end loop;* ^0 U/ g1 J2 e: O& K
dbms_output.put_line(' 成功录入数据!');8 P: X$ H& m- u5 G+ d1 B
commit;
T# [5 L& w. H8 k end;
( [% q! W9 L* } 二、从已有表中往入另一张表导数据, @5 `8 l$ J5 S6 A
create or replace procedure TestProc is. y2 {/ b- _$ x( y5 z
begin
3 h* M3 k4 O0 j8 W8 Z9 x5 V |2 n for c in(select id, name from test2) loop% X& v) h9 N/ r; q
insert into test/ V8 X! N, F# k6 }" ]/ h: S* t9 E) o
(id,
6 Z$ M4 u% z/ Z0 A name)7 o0 j% ^$ w/ Z, x
values
7 g, d6 v+ n+ c (test_seq.nextval, c.name);7 L9 U3 ^! N- E9 E1 c. S0 i3 |
end loop;, [$ ?4 M, `* s3 t" D- C1 ]' q- w B
end TestProc; |