1.create table (x int);
2 create or replace procudure proc1 --使用了绑定变量
as
begin
for i in 1..10000
loop
execute immediate
'insert into m vlues(:x)' using i;
end loop;
end;
3 create or replace procudure proc1 --未使用绑定变量
as
begin
for i in 1..10000
loop
execute immediate
'insert into m vlues('||x|'|)' ;
end loop;
end;
4 set time on;
5 execute pro2;
6. execute pro1;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13824386/viewspace-695537/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13824386/viewspace-695537/