PROGRAMS ON FUNCTIONS:

1. Write a function display Maximum salary?
2. Write a function display the annual salary of maximum salary?
3. Write a function input any number and find out the factorial?
4. Write a function to find out the sum of salaries of maximum salary and minimum salary?
5. Write a function display the highest Experience employee hire date?
6. Write a function display the maximum salary employee name joined in the  year 81?

1A)CREATE or REPLACE function FUN1

      Return Number

      IS

      C Number;

      BEGIN

      SELECT Max(sal) into c from EMP;

      Return C;

      END; 

2A)CREATE or REPLACE FUNCTION fun2

      Return Number

      IS

      C Number;

      BEGIN

      SELECT SAL*12 INTO C FROM EMP WHERE SAL=(SELECT MAX(SAL) FROM EMP);

      RETURN C;

      END;

3A)CREATE or REPLACE FUNCTION FUN3

      (N IN NUMBER)

      RETURN NUMBER

      IS 

      F NUMBER:=1;

      BEGIN

      FOR I IN 1..N 

      LOOP

      F:=F*I;

      END LOOP;

      RETURN F;

      END;

4A)CREATE or REPLACE function f2

       RETURN NUMBER

       IS

       C NUMBER;

       BEGIN

       SELECT MAX(sal)+MIN(sal) into C from EMP;

       RETURN C;

       END;

5A)CREATE OR REPLACE FUNCTION FUN5
      RETURN DATE
      IS
      C DATE;
      BEGIN
      SELECT MIN(HIREDATE) INTO C FROM EMP;
      RETURN C;
      END;
6A)CREATE OR REPLACE FUNCTION FUN6
       RETURN VARCHAR2
       IS
       C VARCHAR2(15);
       BEGIN
       SELECT ENAME INTO C FROM EMP WHERE SAL=(SELECT MAX(SAL) FROM EMP              WHERE TO_CHAR(HIREDATE,'YY')='81');
       RETURN C;
       END;