Oracle COSH() Function

Oracle COSH() is a built-in function that returns the hyperbolic cosine of a specified value.

Oracle COSH() syntax

Here is the syntax for the Oracle COSH() function:

COSH(num)

Parameters

num

Required. It can be any numeric data type or any non-numeric data type that can be implicitly converted to a numeric data type.

Return Value

The Oracle COSH() function returns the hyperbolic cosine of the specified value.

If any parameter is NULL, COSH() will return NULL.

Oracle COSH() Examples

Here are some examples that demonstrate the usage of the Oracle COSH() function.

Basic Usage

SELECT
    COSH(0)
FROM dual;

Output:

   COSH(0)
__________
         1

NULL Parameters

If any parameter is NULL, COSH() will return NULL.

SET NULL 'NULL';
SELECT
    COSH(NULL)
FROM dual;

Output:

   COSH(NULL)
_____________
         NULL

In this example, we use the statement SET NULL 'NULL'; to display NULL values as the string 'NULL'.

Conclusion

Oracle COSH() is a built-in function that returns the hyperbolic cosine of a specified value.