• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / Oracle / function / TANH Function in Oracle SQL – PLSQL

TANH Function in Oracle SQL – PLSQL

October 29, 2012 by techhoneyadmin

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.


Filed Under: function Tagged With: how to use tanh function in oracle database query, how to use tanh function in oracle plsql, how to use tanh function in oracle sql, syntax and example of tanh function in oracle database query, syntax and example of tanh function in oracle plsql, syntax and example of tanh function in oracle sql, tanh function in oracle plsql, tanh function in oracle sql, TANHPLSQL, using tanh function in oracle database query, using tanh function in oracle plsql, using tanh function in oracle sql

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in