Oracle PL/SQL Tutorial/Numerical Math Functions/COS

COS(1415926)

   <source lang="sql">

SQL> select COS(45 * 3.1415926) from dual; COS(45*3.1415926)

---

              -1</source>
   
  

COS(1415926)

   <source lang="sql">

SQL> select COS(90 * 3.1415926) from dual; COS(90*3.1415926)

---

               1</source>
   
  

Using the COS function to find the cosine of 60 degrees

   <source lang="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 COS(value2*2*3.1416/360) FROM myTable

 2  /

COS(VALUE2*2*3.1416/360)

---

             .499997879

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

 2  /

Table dropped.</source>