declare
v_sql varchar2(2000) :=”;
v_num number;
begin
1. execute immediate用法1:立刻执行sql语句
v_sql := ‘create or replace view myview as select id,name from student’;
execute immediate v_sql;
execute immediate用法2:立刻执行sql语句,并赋值给某个变量
v_sql := ‘select count(1) from student’;
execute immediate v_sql into v_num;- execute immediate用法3:带参数的sql
v_sql:=’select * from student t where t.name=:1 and t.age=:2’;
execute immediate v_sql using ‘ZhangSan’,23;
- execute immediate用法3:带参数的sql
end proc_test;
/