SIN Function in Oracle SQL – PLSQL

The SIN function in Oracle SQL / PLSQL is used to calculate sine of numeric value where numeric value is provided in radian format.

It’s mathematically equal to SIN(N).

Syntax for the SIN function in Oracle SQL / PLSQL is:

SELECT SIN(radian)
FROM table_name;

Let’s take an example for understanding:

Suppose we want to get the sine of 30 degree.

SELECT SIN(30*22/(7*180))
FROM dual;

The output of the above statement will be:

SIN(30*22/(7*180))
0.50018250219967

Notice that we have changed 30 degrees into radians while passing it in SIN function.


Tagged , , , , , , , , , , , . Bookmark the permalink.