IT Courses

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 HIREDATE=(SELECT MAX(HIREDATE)
    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 HIREDATE=(SELECT MIN(HIREDATE)
    FROM EMP);
    FETCH C INTO M;
    DBMS_OUTPUT.PUT_LINE(M.ENAME||' '||M.EMPNO||' '||M.SAL||' '||M.COMM||'    
    '||M.HIREDATE);
    CLOSE C;
    END;