SQL$HELP72.HLB  —  RETURN Control, Examples
    Example 1: Specifying the RETURN statement in a stored function

    SQL> CREATE MODULE utility_functions
    cont>   LANGUAGE SQL
    cont>   FUNCTION abs (IN :arg INTEGER) RETURNS INTEGER
    cont>      COMMENT 'Returns the absolute value of an integer';
    cont>   BEGIN
    cont>      RETURN CASE
    cont>             WHEN :arg < 0 THEN - :arg
    cont>             ELSE :arg
    cont>             END;
    cont>   END;
       .
       .
       .
    cont> END MODULE;
Close Help