摘要：
第一种方式：declare lv_deptno emp.deptno%type:=10;lv_ename emp.ENAME%type:='';cursor find_emps_bydeptno(v_deptno number) is select ename from emp where deptno=v_deptno; begin open find_emps_bydeptno(lv_deptno); loop fetch find_emps_bydeptno into lv_ename; exit when find_emps_bydeptno%notfound; dbm 阅读全文
