PROGRAMS ON CURSORS

Q)WRITE A PL/SQL BLOCK TO DISPLAY THE EMPLOYEE DETAILS WHO ARE WORKING UNDER BLAKE AND CLARK?
A)DECLARE
    A  EMP%ROWTYPE;
    CURSOR  C  IS  SELECT * FROM  EMP  WHERE  MGR IN(SELECT  EMPNO FROM EMP    
    WHERE ENAME='BLAKE' OR ENAME ='CLARK');
    BEGIN
    OPEN C;
    LOOP
    FETCH C INTO A;
    EXIT WHEN C%NOTFOUND;
    DBMS_OUTPUT.PUT_LINE(A.EMPNO||' '||A.ENAME||' '||A.SAL);
    END LOOP;
    DBMS_OUTPUT.PUT_LINE(C%ROWCOUNT||'RECORDS ARE FOUND');
    CLOSE C;
    END;