批量插入数据

SQL> create table t01 (id number constraint pk_t01_id primary key,name varchar2(200));

Table created.

SQL> begin
  2  for i in 1..50000 loop
  3  insert into t01 values(i,'a');
  4  end loop;
  5  commit;
  6  end;
  7  /

PL/SQL procedure successfully completed.

SQL> select count(*) from t01;

  COUNT(*)
----------
     50000
     

SQL> create table test(a int);

Table created.

SQL> insert into test select level from dual connect by level<51;

50 rows created.