;

   LEAST function with eight 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), P8 

VarChar(254))

 RETURNS VarChar(254)

 LANGUAGE SQL

 SPECIFIC LEASTOracle8

 DETERMINISTIC

 CONTAINS SQL

 NO EXTERNAL ACTION

 RETURN 

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

;

   LEAST function with nine 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), P8 

VarChar(254)

                     , P9 VarChar(254))

 RETURNS VarChar(254)

 LANGUAGE SQL

 SPECIFIC LEASTOracle9

 DETERMINISTIC

 CONTAINS SQL

 NO EXTERNAL ACTION

 RETURN 

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

;

   LEAST function with ten 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), P8 

VarChar(254)

                     , P9 VarChar(254),P10 VarChar(254))

 RETURNS VarChar(254)

358 

MySQL to DB2 UDB Conversion Guide