create or replace procedure proc1
as
begin
for i in 1..100000
loop
execute immediate
'insert into t values('||i||')';
commit;
end loop;
end;
/
set timing on;
execute proc1;
select t.sql_text,t.sql_id,t.parse_calls,t.executions from v$sql t where sql_text like 'insert into t%';
create or replace procedure proc2
as
begin
for i in 1..100000
loop
execute immediate
'insert into t values(:x)' using i;
commit;
end loop;
end;
/
execute proc2;
出自 《收获,不止oracle》