hyena(hyena) ( ) 我看不懂你写的啊 我的代码是这样的 ---- my_query varchar2(400); my_query:='select a.InTime1, a.OutTime4 into first_InTime,last_OutTime from xworkType a inner join (select * from xDutyPlan where employeeid='||v_empTime.employeeid||' )b on a.WorkTypeID=b.D'||Date_d ;
EXECUTE IMMEDIATE my_query INTO emp_rec USING v_empTime.employeeid;----------- Date_d 是一个参数来着,根据他来获得对应的字段编号, v_empTime.employeeid 是在前面得到的人员编号,我现在是想得到 first_InTime,last_OutTime ,这话我该怎么写呢?
declare emp_No varchar2(10); m_query varchar2(100); type t_sor is ref cursor; v_sor t_sor; begin m_query:=' select * from employee where empno='||emp_No; open v_sor for m_query; loop fetch v_sor into 变量; exit when v_sor%notfound; dbms_output.put_line(变量); end loop; close v_Sor; end; /
比如是这样, 传进一个变量,
我要执行的语句是
select empno,depID, D||'01' from employee where empno='||emp_No;
这里面,'01' 就是传进来的参数来着,
实际上, D01 才是我要查询的字段,
那请问 我该怎么写呢?
sql_stmt := ’SELECT * FROM emp WHERE empno = :id’;
EXECUTE IMMEDIATE sql_stmt INTO emp_rec USING emp_id;
是什么意思啊?
他们的定义是什么?
sql_stmt VARCHAR2(200);
emp_id NUMBER(4) := 7566;
emp_rec emp%ROWTYPE;using 是指传入一个参数
我看不懂你写的啊
我的代码是这样的
----
my_query varchar2(400); my_query:='select a.InTime1, a.OutTime4 into first_InTime,last_OutTime
from xworkType a
inner join (select * from xDutyPlan where employeeid='||v_empTime.employeeid||'
)b on a.WorkTypeID=b.D'||Date_d ;
EXECUTE IMMEDIATE my_query INTO emp_rec USING v_empTime.employeeid;-----------
Date_d 是一个参数来着,根据他来获得对应的字段编号,
v_empTime.employeeid 是在前面得到的人员编号,我现在是想得到 first_InTime,last_OutTime ,这话我该怎么写呢?
emp_No varchar2(10);
m_query varchar2(100);
type t_sor is ref cursor;
v_sor t_sor;
begin
m_query:=' select * from employee where empno='||emp_No;
open v_sor for m_query;
loop
fetch v_sor into 变量;
exit when v_sor%notfound;
dbms_output.put_line(变量);
end loop;
close v_Sor;
end;
/