在大多数时候我们在设计程序的时候都遵循下面的步骤： 1、打开游标2、开始循环 3、从游标中取值 4、检查那一行被返回 5、处理 6、关闭循环 7、关闭游标例如：DECALRECURSOR c_dept IS SELECT deptno,dname FROM dept ORDER BY deptno;CURSOR c_emp (p_dept VARACHAR2) IS SELECT ename,salary FROM emp WHERE deptno=p_dept ORDER BY enamev_tot_salary EMP.SALARY%TYPE;BEGINFOR r_dept IN c_deptLOOPDBMS_OUTPUT.PUT_LINE('Department:'|| r_dept.deptno||'-'||r_dept.dname);v_tot_salary:=0;FOR r_emp IN c_emp(r_dept.deptno)LOOPDBMS_OUTPUT.PUT_LINE('Name:'|| v_ename||' salary:'||v_salary);v_tot_salary:=v_tot_salary+v_salary;END LOOP;DBMS_OUTPUT.PUT_LINE('Toltal Salary for dept:'|| v_tot_salary);END LOOP;END;