--带参数的光标
--查询某个部门中员工的姓名
declare
cursor cemp(dno number) is select ename from emp where deptno=dno;
pename emp.ename%type;
begin
open cemp(20);
loop
fetch cemp into pename;
exit when cemp%notfound;
DBMS_OUTPUT.PUT_LINE(pename);
end loop;
close cemp;
end;
带参数的光标
最新推荐文章于 2024-10-02 11:52:29 发布