摘要:
带参数的光标--查询10号部门的员工 1 set serveroutput on 2 3 declare 4 5 --带参数的光标 6 cursor cemp (dno number) is select ename from emp where deptno=dno; 7 pename emp.ename%type; 8 9 begin10 open cemp('10');11 12 loop13 fetch cemp into pename;14 exit when cemp%notfound;15 16 ... 阅读全文