1，明示Cursor

SET serveroutput ON
SET verify OFF
DECLARE
  CURSOR CUR_EMP
  IS
    SELECT EMPLOYEE_ID,
      FIRST_NAME
    FROM EMPLOYEES
    WHERE DEPARTMENT_ID =
      &DEPARTMENT_ID;
  REC CUR_EMP%ROWTYPE;
BEGIN
  OPEN CUR_EMP;
  LOOP
    FETCH CUR_EMP INTO REC;
    EXIT
  WHEN CUR_EMP%NOTFOUND;
    DBMS_OUTPUT.PUT_LINE(REC.EMPLOYEE_ID || ' ' || REC.FIRST_NAME);
  END LOOP;
  CLOSE CUR_EMP;
END;
/

PL/SQLプロシージャが正常に完了しました。

201 Michael
202 Pat