Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Numerical Math Functions

 

Using the TAN function to find the tangent 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 TAN(value1*2*3.1416/360)FROM myTable   2  / TAN(VALUE1*2*3.1416/360) ------------------------               .577351902 SQL> SQL> -- clean the table SQL> drop table myTable   2  / Table dropped.