plsql中使用绑定变量

摘自《基于oracle的sql优化》

实例：

declare

vc_name varchar2(10);

begin

execute immediate 'select ename from emp where empno = :1' into v_name using 1234;

dbms_output.put_line(v_name);

end;

/

declare

v_sql varchar2(1000);

v_sql2 varchar2(10000);

n_num number;

n_num2 number;

begin

v_sql := 'insert into emp(empno,ename,job)values(:1,:2,:3';

execute immediate v_sql using 1234,'test','aaa'；

n_num := sql%rowcount;

commit;

end;

/

declare

v_column varchar2(10);

v_sql varchar2(2000);

v_ename varchar2(200);

begin

v_column := 'empno';

v_sql := 'delete from emp where '||  v_column || ' = :1 returning ename into :2';

execute immediate v_sql using 123 returing into v_name;