Using the SIN function to find the sine of 30 degrees : SIN « Numerical Math Functions « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Numerical Math Functions
3. SIN

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 SIN(value1*2*3.1416/360)FROM myTable
  2  /

SIN(VALUE1*2*3.1416/360)
------------------------
               .50000106

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

Table dropped.