END

          END

     ELSE CASE

          WHEN P3 <= P4

          THEN CASE

               WHEN P3 <= P5 THEN P3

               ELSE               P5

               END

          ELSE CASE

               WHEN P4 <= P5 THEN P4

               ELSE               P5

               END

          END

     END

END

;

   LEAST function with six parameters

CREATE FUNCTION LEAST (P1 VarChar(254), P2 VarChar(254), P3 VarChar(254), P4 

VarChar(254)

                     , P5 VarChar(254), P6 VarChar(254))

 RETURNS VarChar(254)

 LANGUAGE SQL

 SPECIFIC LEASTOracle6

 DETERMINISTIC

 CONTAINS SQL

 NO EXTERNAL ACTION

 RETURN 

LEAST(LEAST(P1,P2,P3),LEAST(P4,P5,P6))

;

   LEAST function with seven parameters

CREATE FUNCTION LEAST (P1 VarChar(254), P2 VarChar(254), P3 VarChar(254), P4 

VarChar(254)

                     , P5 VarChar(254), P6 VarChar(254), P7 VarChar(254))

 RETURNS VarChar(254)

 LANGUAGE SQL

 SPECIFIC LEASTOracle7

 DETERMINISTIC

 CONTAINS SQL

 NO EXTERNAL ACTION

 RETURN 

LEAST(LEAST(P1,P2,P3,P4),LEAST(P5,P6,P7))

 Appendix A. Sample code for user defined functions 

357