Oracle TANH() Function

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

Oracle TANH() syntax

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

TANH(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

Oracle TANH() function returns the hyperbolic tangent of a specified value.

If the parameter is BINARY_FLOAT, TAN() returns BINARY_DOUBLE. Otherwise TANH() returns the same numeric data type as the parameter.

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

Oracle TANH() Examples

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

Basic Usage

SELECT
    TANH(0.2)
FROM dual;

Output:

                                  TANH(0.2)
___________________________________________
   0.19737532022490400073815731881101566839

NULL Parameters

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

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

Output:

   TANH(NULL)
_____________
         NULL

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

Conclusion

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