Oracle之集合写法改造

drop table t purge;
create table t ( x int );
set timing on
begin
    for i in 1 .. 100000
    loop
     insert into t values (i);   
    end loop;
  commit;
end;
/

--集合写法改造：


drop table t purge;
create table t ( x int );
insert into t select rownum from dual connect by level<=100000;
commit;