Oracle PL/SQL Tutorial/Numerical Math Functions/COSH

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

COSH(3.1415926)

   <source lang="sql">

SQL> select COSH(3.1415926) from dual; COSH(3.1415926)


    11.5919527</source>
   
  

Using the COSH function to find the hyperbolic cosine of 30 degrees

   <source lang="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> SQL> SELECT COSH(value1*2*3.1416/360)FROM myTable

 2  /

COSH(VALUE1*2*3.1416/360)


              1.14023899

SQL> SQL> SQL> -- clean the table SQL> drop table myTable

 2  /

Table dropped.</source>