IT Courses

Q)WRITE A PL/SQL BLOCK DISPLAY MAX SAL EMPLOYEE NAME AND MIN SAL EMPLOYEE NAME WORKING UNDER SALES DEPARTMENT?
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 WHERE DEPTNO=
    (SELECT DEPTNO FROM DEPT WHERE DNAME='SALES'));
    FETCH C INTO M;
    DBMS_OUTPUT.PUT_LINE(M.ENAME);
    CLOSE C;
    OPEN C FOR SELECT * FROM EMP WHERE SAL=(SELECT MIN(SAL) FROM EMP WHERE DEPTNO=
    (SELECT DEPTNO FROM DEPT WHERE DNAME='SALES'));
    FETCH C INTO M;
    DBMS_OUTPUT.PUT_LINE(M.ENAME);
    CLOSE C;
    END;