DECLARE
  V_EMPNO    EMP.EMPNO%TYPE;
  V_ENAME    EMP.ENAME%TYPE;
 CURSOR V_EMP IS SELECT EMPNO,ENAME INTO V_EMPNO,V_ENAME FROM EMP WHERE DEPTNO = 20;
 BEGIN
  OPEN V_EMP;
 LOOP
  FETCH V_EMP INTO V_EMPNO,V_ENAME;
  DBMS_OUTPUT.PUT_LINE('EMPNO :'||V_EMPNO||','||'ENAME :'||V_ENAME);
    EXIT WHEN V_EMP%NOTFOUND;
END LOOP;
  CLOSE V_EMP;
 END;
/
