WHEN P2 <= P3 THEN P2
     ELSE               P3
     END
END
;
                                                   
  
   LEAST function with four parameters
   
                                                                          
CREATE FUNCTION LEAST (P1 VarChar(254), P2 VarChar(254), P3 VarChar(254), P4 
VarChar(254))
 RETURNS VarChar(254)
 LANGUAGE SQL
 SPECIFIC LEASTOracle4
 DETERMINISTIC
 CONTAINS SQL
 NO EXTERNAL ACTION
 RETURN 
CASE
WHEN P1 <= P2
THEN CASE
     WHEN P1 <= P3
     THEN CASE
          WHEN P1 <= P4 THEN P1
          ELSE               P4
          END
     ELSE CASE
          WHEN P3 <= P4 THEN P3
          ELSE               P4
          END
     END
ELSE CASE
     WHEN P2 <= P3
     THEN CASE
          WHEN P2 <= P4 THEN P2
          ELSE               P4
          END
     ELSE CASE
          WHEN P3 <= P4 THEN P3
          ELSE               P4
          END
     END
END
;
                                                   
  
   LEAST function with five parameters
   
 Appendix A. Sample code for user defined functions 
355






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved