Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Numerical Math Functions

 

Using the SIN function to find the sine of 30 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 SIN(value1*2*3.1416/360)FROM myTable   2  / SIN(VALUE1*2*3.1416/360) ------------------------                .50000106 SQL> SQL> -- clean the table SQL> drop table myTable   2  / Table dropped.