执行如下批处理命令:
declare
maxrecords constant int := 100000;
i int := 1;
begin
for i in 1 .. 20000 loop
insert into test2 (id, name) values (i, to_char(9999 + i));
end loop;
dbms_output.put_line(' 成功录入数据!');
commit;
end;
2023-07-27 12:28:46
执行如下批处理命令:
declare
maxrecords constant int := 100000;
i int := 1;
begin
for i in 1 .. 20000 loop
insert into test2 (id, name) values (i, to_char(9999 + i));
end loop;
dbms_output.put_line(' 成功录入数据!');
commit;
end;