Oracle Number Function - Oracle/PLSQL SIN Function






This Oracle tutorial explains how to use the Oracle/PLSQL SIN function.

SIN returns the sine of a value. The SIN function take arguments in radians where:

radians = (angle * 2 * 3.1416 / 360)

Syntax

The syntax for the Oracle/PLSQL SIN function is:

SIN( n )

n is a number. It is an angle expressed in radians.

Example


SQL> select sin(3.1415) from dual;

SIN(3.1415)
-----------
 .000092654

SQL>

Using SIN function to find the sine of 30 degrees: 


SQL> select sin(30*2*3.1415926/360) From dual;

SIN(30*2*3.1415926/360)
-----------------------
             .499999992

SQL>