Oracle SINH() Function

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

Oracle SINH() syntax

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

SINH(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 SINH() function returns the hyperbolic sine of the specified value.

SINH() returns BINARY_DOUBLE if the parameter is BINARY_FLOAT. Otherwise SINH() returns the same numeric data type as the parameter.

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

Oracle SINH() Examples

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

Basic Usage

SELECT
    SINH(0.2)
FROM dual;

Output:

                                    SINH(0.2)
_____________________________________________
   0.2013360025410939876255682430103173729745

NULL Parameters

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

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

Output:

   SINH(NULL)
_____________
         NULL

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

Conclusion

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