Oracle SIN() Function

Oracle SIN() is a built-in function that returns the sine of a given value in radians.

Oracle SIN() syntax

Here is the syntax for the Oracle SIN() function:

SIN(num)

Parameters

num

Required. It can be any numeric data type or any non-numeric data type that can be implicitly converted to a numeric data type.

Return Value

Oracle SIN() function returns the sine of a given value in radians.

If the parameter is BINARY_FLOAT, SIN() returns BINARY_DOUBLE. Otherwise SIN() returns the same numeric data type as the parameter.

If any parameter is NULL, SIN() will return NULL.

Oracle SIN() Examples

Here are some examples that demonstrate the usage of the Oracle SIN() function.

Basic Usage

SELECT
    SIN(0.2)
FROM dual;

Output:

                                     SIN(0.2)
_____________________________________________
   0.1986693307950612154594126271183897503703

NULL Parameters

If any parameter is NULL, SIN() will return NULL.

SET NULL 'NULL';
SELECT
    SIN(NULL)
FROM dual;

Output:

   SIN(NULL)
____________
        NULL

In this example, we use the statement SET NULL 'NULL'; to display NULL values as the string 'NULL'.

Conclusion

Oracle SIN() is a built-in function that returns the sine of a given value in radians.