pl/sql 绑定变量使用

1,

var x number

exec :x:=1048

select user_id from fnd_user where user_id=:x;

2,

declare

  x number := 1048;

  v number;

begin

  select user_id into v from fnd_user where user_id = x;

  dbms_output.put_line(v);

end;

3, 

declare

   v varchar2(20):='1,2,3,4,5,6,7';

   r number;

   t varchar2(200);

begin

t:='select 1 from dual where 1 in ('||v||')';

execute immediate t into r;

dbms_output.put_line(r);

end;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22333206/viewspace-612567/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22333206/viewspace-612567/