Oracle 中批量导入大量测试数据的方法

执行如下批处理命令：

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;

转载于:https://www.cnblogs.com/onsuccessway/p/3334654.html