Oracle Essays-Declaring functions

--Declaring a function

--replace Replace put back

--sal: Monthly Salary

Create or Replace function Fn_get_avg_sal (DNO number)

Return number is avgsal emp.sal%type; --Returns and numbers called Avgsal are the types of Sal fields in the EMP employee table

Begin

Select AVG (SAL) into Avgsal from EMP where Detpno=dno; --Query the average of the SAL into to the declared avgsal.

return avgsal;

End Fn_get_avg_sal;

--Call statement

--Pass value 20,20 to the function as the number of the department.

-that is, the query number is 20 of the department's average employee salary, dual: pseudo-table.

Select Fn_get_avg_sal from dual;

Oracle Essays-Declaring functions