点击(此处)折叠或打开
- create or replace procedure proc_test(
- --参数区域
- )
- is
- --变量区域
- --sql脚本
- v_sql varchar2(2000) :='';
- --记录学生数量
- v_num number;
- begin
- --执行区域
-
- -- 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;
-
- end proc_test;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29209863/viewspace-2141106/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29209863/viewspace-2141106/