Go语言视频零基础入门到精通

admin

rem **************************************
rem **简单常用的Execute Immediate用法
rem **************************************begin
  execute immediate 'create table hd_train_sql_table(user_code varchar2(2))';
end;   
rem **************************************
rem **给动态语句传值
rem **************************************declare
v_depname varchar2(20) := 'testing';
v_loc varchar2(10) := 'ShangHai';
begin
  execute immediate
    'insert into dept(deptno,dname,loc) values(:1,:2,:3)'
    using 55,v_depname,v_loc;
  commit;
end;   
rem **************************************
rem **单记录查询(into)
rem **************************************declare
  v_cnt number;
begin
  execute immediate 'select count(1) from emp'  
  into v_cnt;
  dbms_output.put_line(v_cnt);
end;  
rem **************************************
rem **绑定变量参数(in out)
rem **************************************declare
  v_sql varchar2(1000);
  v_param1 varchar2(30) := 'a';
  v_param2 varchar2(30) := 'b';
begin
  --使用过程
  v_sql := 'begin hand_train_pkg.hand_procedure(:v1,:v2);end;';
  execute immediate v_sql
    using in v_param1,in out v_param2;
    dbms_output.put_line(v_param2);  
end;   
欢迎访问java学习者论坛：http://www.javaxxz.com

忘记

QQQQQQQQQQQQQQQQQQQQ

忘记

QQQQQQQQQQQQQQQQQQQQQQQ