CREATE FUNCTION  get_max_sal(p_dname IN dept.dname%TYPE)

  RETURN emp.sal%TYPE  IS

  v_sal              emp.sal%TYPE;

  v_max_sal     emp.sal%TYPE;

  v_deptno       emp.deptno%TYPE;

 CURSOR c_emp IS

    SELECT sal

      FROM emp

      WHERE ;

BEGIN

  v_max_sal :;

  SELECT deptno INTO v_deptno FROM dept WHERE ;

  OPEN c_emp;

  LOOP

    FETCH c_emp INTO v_sal;

    EXIT WHEN c_emp%NOTFOUND;

    IF (v_sal > v_max_sal) THEN

      v_max_sal := v_sal;

    END IF;

END LOOP;

 close c_emp;

 return (v_max_sal);

END;

 

Now, use cursor for loop to rewrite the above function.