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;