EXAMPLE ON FUNCTION OVERLOADING

Q)CREATE A PACKAGE TO 1)FIND OUT THE ANNUAL SALARY OF EMPLOYEE WHEN EMPLOYEE NUMBER PASSED AS IN PARAMETER.
                                                   2)FIND OUT THE TOTAL SALARY OF EMPLOYEE WHEN EMPLOYEE NAME PASSED AS IN PARAMETER
                                                   3)FIND OUT THE NUMBER OF EMPLOYEES WHEN DEPARTMENT NUMBER PASSED AS IN PARAMETER
Create or replace Package mypack
IS
Function fun(P_empno in emp.empno%type)
Return Number;
Function(P_ename in emp.ename%type)
Return Number;
Function fun(P_deptno in dept.deptno%type )
Return Number;
End;

Create or Replace Package Body mypack
IS
Function fun(P_empno in emp.empno%type)
Return number
IS
C number;
Begin
select  sal*12 into c from emp where empno=P-empno;
End fun;
Function fun(P_ename in emp.ename%type)
Return number
IS
D number;
Begin
select  sal+nvl(comm,0)  into D from emp where ename=P_ename;
End fun;
Function fun(P_deptno in dept.deptno%type )
Return number
IS
E number;
Begin
select count(*) into E from dept where deptno=P_deptno;
End fun;
End;