PL/SQL PROGRAM USING CURSOR AND ITS ATTRIBUTES

Q)WRITE A PL/SQL BLOCK DISPLAY THE EMPLOYEE DETAILS AND DEPTNAME PASSED AS INPUT VALUE?
A)DECLARE
    A  EMP%TYPE;
    CURSOR C IS SELECT * FROM EMP WHERE DEPTNO=(SELECT DEPTNO FROM EMP           WHERE DNAME='&DNAME');
     BEGIN
     OPEN C;
     LOOP
     FETCH C INTO A;
     IF C%FOUND THEN 
     DBMS_OUTPUT.PUT_LINE(A.EMPNO||' '||A.ENAME||' '||A.DEPTNO||' '||A.HIREDATE||'    '||A.SAL);
      ELSE
      EXIT;
      END IF;
      END LOOP;
      CLOSE C;
      DBMS_OUTPUT.PUT_LINE(C%ROWCOUNT||'RECORDS ARE DISPLAYED');
      END;