oracle绑定变量测试

>drop table t;
Table dropped.
> create table t ( x int );
Table created.

> create or replace procedure proc1
2 as
3 begin
4 for i in 1 .. 10000
5 loop
6 execute immediate
7 'insert into t values ( :x )' using i;
8 end loop

9 end;
10 /
Procedure created.

> create or replace procedure proc2
2 as
3 begin
4 for i in 1 .. 10000
5 loop
6 execute immediate
7 'insert into t values ( '||i||')';
8 end loop;
9 end;
10 /
Procedure created

#打开timing 

hr@ORCL> set timing on
hr@ORCL> exec proc1

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.57
hr@ORCL> exec proc2

PL/SQL procedure successfully completed.

Elapsed: 00:00:05.57