第3章_游标.pptVIP

* DECLARE CURSOR dept_cursor IS SELECT * FROM departments; CURSOR emp_cursor (v_department_id NUMBER) IS SELECT * FROM employees WHERE department_id=v_department_id ORDER BY salary DESC; 【例3-9】用带参数游标的FOR循环依此输出每一个部门编号，在部门编号的下面输出该部门的员工编号和工资，按工资的降序排列。 3.1.5 带参数的游标 * BEGIN FOR dept_record IN dept_cursor LOOP DBMS_OUTPUT.PUT_LINE(‘部门编号为:’|| dept_record.department_id); FOR emp_record IN emp_cursor (dept_record.department_id) LOOP DBMS_OUTPUT.PUT_LINE(‘员工编号为:’|| emp_record.employee_id