JubbaSmail · December 22, 2014 20:02
diff --git a/pl_sql_function.sql b/pl_sql_function.sql
 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;
	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;