create or replace procedure is
begin
for i in 1..100000 loop
execute immediate 'insert into t(x) values ('||i||')';
commit;
endloop;
end;
create or replace procedure is
begin
for i in 1..100000 loop
execute immediate 'insert into t(x) values ('||i||')';
endloop;
commit;
end;
declare @i int
set @i=1
while @i<10000000
begin
INSERT INTO table
()
VALUES
()
set @i=@i+1
end
这样插入太慢了。请大神传授一个快速点的方法