Oracle PL/SQL Tutorial/Numerical Math Functions/TANH

select tanh(0.5)

SQL>
SQL>
SQL>
SQL> select tanh(0.5)
  2  from   dual;
 TANH(0.5)
----------
.462117157
SQL>
SQL>

TANH(1)

SQL> select TANH(1) from dual;
   TANH(1)
----------
.761594156

Using the TANH function to find the hyperbolic tangent of 30 degrees

SQL>
SQL>
SQL> -- create demo table
SQL> create table myTable(
  2    value1           NUMBER(3),
  3    value2           NUMBER(3),
  4    value3           NUMBER(3)
  5  )
  6  /
Table created.
SQL>
SQL> -- prepare data
SQL> insert into myTable(value1,value2, value3) values (30,60,90)
  2  /
1 row created.
SQL> select * from myTable
  2  /
    VALUE1     VALUE2     VALUE3
---------- ---------- ----------
        30         60         90
SQL>
SQL> SELECT TANH(value1*2*3.1416/360)FROM myTable
  2  /
TANH(VALUE1*2*3.1416/360)
-------------------------
                .48047372
SQL>
SQL> -- clean the table
SQL> drop table myTable
  2  /
Table dropped.
SQL>