Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Numerical Math Functions

 

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

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