PL/SQL中的异常及PL/SQL中的控制语句(三)
immediate 'SQL语句字符串';
SQL> remark 创建一个表：
SQL> begin
2 execute immediate
3 'create table hopecalss(claid number,calName char(6))';
4 end;
5 /
PL/SQL procedure successfully completed.
SQL> remark 动态的SQL进行参数的传递 有时候进行结果的变量；
SQL> edit
Wrote file afiedt.buf
1 declare
2 sqlstring varchar2(200);
3 dept_id number(2):=50;
4 dept_name varchar(14):='personnel';
5 location varchar(13):='develop';
6 begin
7 --演示的是usingredients字句的execute immediate
8 sqlstring :='insert into dept values(:1,:2,:3)';
9 execute immediate sqlstring using dept_id,dept_name,location;
10* end;
11 /
PL/SQL procedure successfully completed.
SQL> spool off;
[color=orange][/color][size=x-small][/size]