Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Numerical Math Functions

 

Using the COS function to find the cosine of 60 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 COS(value2*2*3.1416/360) FROM myTable   2  / COS(VALUE2*2*3.1416/360) ------------------------               .499997879 SQL> SQL> -- clean the table SQL> drop table myTable   2  / Table dropped.