oracle存储函数中 dyndql:='select var,a.aaa from aaa a' 变量var如何引用,谁知道,帮帮忙,谢谢了
使用动态SQL绑定var吧,,, 如果待遇好,可以考虑到上海一游
大哥 oracle存储函数中 dyndql:='select var,a.aaa from aaa a' 变量var如何引用,谁知道,帮帮忙,谢谢了 Vdyndql:='select var,a.aaa from aaa a' Execute immediate Vdynsql using var; 这样为什么不行???
select 'Resume', 'Name:'||myName, 'Sex:'||sex, 'Age:'||age, ..... 'Telephone:'||myTelephone into [email protected] from csdn论坛 where 知识或经验 in (with experience in software development, with knowledge of PL/SQL) and 基本技能= understand technical specifications written in English(+) and 可以签合同 >=14 months and 期望薪水 > 0; /
declare vstr varchar2(100); emprow%rowtype; name varchar2(8); begin vstr:='select * into emprow from emp where name=:name'; execete immediate vstr using out emprow ,name; dbms_output.put_line(emprow.name); end;
dyndql:='select var,a.aaa from aaa a'
变量var如何引用,谁知道,帮帮忙,谢谢了
如果待遇好,可以考虑到上海一游
oracle存储函数中
dyndql:='select var,a.aaa from aaa a'
变量var如何引用,谁知道,帮帮忙,谢谢了
Vdyndql:='select var,a.aaa from aaa a'
Execute immediate Vdynsql using var;
这样为什么不行???
'Resume',
'Name:'||myName,
'Sex:'||sex,
'Age:'||age,
.....
'Telephone:'||myTelephone
into [email protected]
from
csdn论坛
where
知识或经验 in (with experience in software development, with knowledge of PL/SQL)
and 基本技能= understand technical specifications written in English(+)
and 可以签合同 >=14 months
and 期望薪水 > 0;
/
vstr varchar2(100);
emprow%rowtype;
name varchar2(8);
begin
vstr:='select * into emprow from emp where name=:name';
execete immediate vstr using out emprow ,name;
dbms_output.put_line(emprow.name);
end;
(效率)最短的时间里学到了尽可能多的东西.