The TANH function in Oracle SQL / PLSQL is used to calculate hyperbolic tangent of numeric value where numeric value is provided in radian format.
It’s mathematically equal to TANH(N).
Syntax for the TANH function in Oracle SQL / PLSQL is:
SELECT TANH(radian)
FROM table_name;
Let’s take an example for understanding:
Suppose we want to get the hyperbolic tangent of 30 degree.
SELECT TANH(30*22/(7*180)) FROM dual;
The output of the above statement will be:
| TANH(30*22/(7*180)) |
| 0.480634857866646 |
Notice that we have changed 30 degrees into radians while passing it in TANH function.