CREATE FUNCTION GREATEST (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 GREATESTOracle7

 DETERMINISTIC

 CONTAINS SQL

 NO EXTERNAL ACTION

 RETURN 

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

;

   GREATEST function with eight parameters

CREATE FUNCTION GREATEST (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 GREATESTOracle8

 DETERMINISTIC

 CONTAINS SQL

 NO EXTERNAL ACTION

 RETURN 

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

;

   GREATEST function with nine parameters

CREATE FUNCTION GREATEST (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 GREATESTOracle9

 DETERMINISTIC

 CONTAINS SQL

 NO EXTERNAL ACTION

 RETURN 

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

350 

MySQL to DB2 UDB Conversion Guide