17,140
社区成员




create or replace procedure insert_tab
is
v_insert_tab varchar2(1000);
begin
for i in 1..100 loop
v_insert_tab :='insert into test_tab(id,name) values ( 1,"aa")';
commit;
end loop;
end insert_tab;
create or replace procedure insert_tab
is
begin
for i in 1..100 loop
insert into test_tab(id,name) values (i,'aa');
commit;
end loop;
end insert_tab;
create or replace procedure insert_tab
is
v_insert_tab varchar2(1000);
begin
for i in 1..100 loop
v_insert_tab :='insert into test_tab(id,name) values ( 1,"aa")';
commit;
end loop;
end insert_tab;
create or replace procedure insert_tab
is
begin
for i in 1..100 loop
v_insert_tab :='insert into test_tab(id,name) values (1,''aa'')';
execute immediate v_insert_tab;
commit;
end loop;
end insert_tab;