Q)WRITE A PL/SQL BLOCK DISPLAY THE MAX SAL AND MIN SAL EMPLOYEE DETAILS?

Q)WRITE  A PL/SQL BLOCK DISPLAY THE MAX SAL AND MIN SAL EMPLOYEE DETAILS?

A)DECLARE
    M EMP%ROWTYPE;
    TYPE MAX_MIN_CUR IS REF CURSOR;
    C MAX_MIN_CUR;
    BEGIN
    OPEN C FOR SELECT * FROM EMP WHERE SAL=(SELECT MAX(SAL) FROM EMP);
    FETCH C INTO M;
    DBMS_OUTPUT.PUT_LINE(M.ENAME||' '||M.EMPNO||' '||M.SAL||' '||M.COMM||'      '||M.HIREDATE);
    CLOSE C;
    OPEN C FOR SELECT * FROM EMP WHERE SAL=(SELECT MIN(SAL) FROM EMP);
    FETCH C INTO M;
    DBMS_OUTPUT.PUT_LINE(M.ENAME||' '||M.EMPNO||' '||M.SAL||' '||M.COMM||'    '||M.HIREDATE);
   CLOSE C;
   END;