Oracle PL/SQL Tutorial/Numerical Math Functions/SINH — различия между версиями

Материал из SQL эксперт
Перейти к: навигация, поиск
м (1 версия)
 
(нет различий)

Текущая версия на 10:08, 26 мая 2010

Hyperbolic Trig Functions

  1. SINH returns the hyperbolic sine of a value.
  2. COSH returns the hyperbolic cosine of a value.
  3. TANH returns the hyperbolic tangent of a value.

Hyperbolic trigonometric functions take arguments in radians where, radians = (angle*2* 3.1416 / 360)

14. 20. SINH 14. 20. 1. Hyperbolic Trig Functions 14. 20. 2. <A href="/Tutorial/Oracle/0280__Numerical-Math-Functions/UsingtheSINHfunctiontofindthehyperbolicsineof30degrees.htm">Using the SINH function to find the hyperbolic sine of 30 degrees</a> 14. 20. 3. <A href="/Tutorial/Oracle/0280__Numerical-Math-Functions/SINH1.htm">SINH(1)</a>

SINH(1)

SQL> select SINH(1) from dual;
   SINH(1)
----------
1.17520119


Using the SINH function to find the hyperbolic sine of 30 degrees

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 SINH(value1*2*3.1416/360)FROM myTable
  2  /
SINH(VALUE1*2*3.1416/360)
-------------------------
                .54785487
SQL>
SQL> -- clean the table
SQL> drop table myTable
  2  /
Table dropped.