execute immediate的问题

[chenranlw]

execute immediate不能直接输出变量吗，必须是sql语句吗！￣

[xiaoxiao1984]

dbms_output.put_line(str);
输出str字符串;

[czbbbs]

能！
参考以下：
execute immediate 'select name,salary from emp where id=:1'
using p_id
returning into v_name,v_salary; --动态SQL为查询语句

[多壮志]

declare
r integer;
begin
execute immediate 'select count(*) from tab' into r;
dbms_output.put_line(r);
end;