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.