CREATE OR REPLACE FUNCTION SUM_SALARY
(
  DEP_ID IN NUMBER
) RETURN NUMBER AS
x number;
BEGIN
  select sum(salary) into x from employees where department_id = DEP_ID;
  return x;
END;