The COS function in Oracle SQL / PLSQL is used to calculate cosine of numeric value where numeric value is provided in radian format.
It’s mathematically equal to COS(N).
Syntax for the COS function in Oracle SQL / PLSQL is:
SELECT COS(radian)
FROM table_name;
Let’s take an example for understanding:
Suppose we want to get the cosine of 30 degree.
SELECT COS(30*22/(7*180)) FROM dual;
The output of the above statement will be:
| COS(30*22/(7*180)) |
| 0.86592001044743 |
Notice that we have changed 30 degrees into radians while passing it in COS function.