CREATE OR REPLACE FUNCTION fun1(e IN NUMBER)
RETURN INTEGER IS
  s INTEGER;
BEGIN
  SELECT sal INTO s
  FROM emp
  WHERE empno = e;
  RETURN s;
END;
/
