Oracle/PL/SQL
15일차 # 7-21: Cursor with Parameters
Bohemian life
2012. 4. 24. 21:41
- parameters: name, data type, but NO size
- 파라미터 값에 따라 active set이 달라짐
declare
cursor emp_cur(d_no number) is
select empno, ename, job, sal
from emp
where deptno = d_no;
rec_emp_cur emp_cur%rowtype;
begin
open emp_cur(10); --> cursor open 시 파라미터 입력
loop
fetch emp_cur into rec_emp_cur;
exit when emp_cur%notfound;
p(rec_emp_cur.job||', '||rec_emp_cur.ename||'('||rec_emp_cur.empno
||')''s salary is '||rec_emp_cur.sal);
end loop;
close emp_cur;
end;
/