The PLSQL SIN function is used to return the sine of a numeric value. The SIN function accepts one parameter which is the number whose sine needs to be calculated. The SIN function returns a value of the numeric data type.

This function takes as an argument any numeric data type as well as any non-numeric data type that can be implicitly converted to a numeric data type. If in any case, the argument is BINARY_FLOAT, then the SIN function returns BINARY_DOUBLE.

**Syntax:**

SIN(number)

**Parameters Used:**

**number –** It is used to specify the number whose sine needs to be calculated.

**Return Value:**

The SIN function in PLSQL returns a numeric value.

**Supported Versions of Oracle/PLSQL:**

- Oracle 12c
- Oracle 11g
- Oracle 10g
- Oracle 9i
- Oracle 8i

**Example-1:** Using positive numeric value as an argument in the SIN function.

DECLARE Test_Number1 number := 0.5; BEGIN dbms_output.put_line(SIN(Test_Number1)); END;

**Output:**

0.4794255386042030002732879352155713880819

**Example-2:** Using 0 value as an argument in the SIN function.

DECLARE Test_Number1 number := 0; BEGIN dbms_output.put_line(SIN(Test_Number1)); END;

**Output:**

0

**Example-3:** Using 1 value as an argument in the SIN function.

DECLARE Test_Number1 number := 1; BEGIN dbms_output.put_line(SIN(Test_Number1)); END;

**Output:**

0.8414709848078965066525023216302989996233

**Example-4:** Using a negative value as an argument in the SIN function.

DECLARE Test_Number1 number := -5; BEGIN dbms_output.put_line(SIN(Test_Number1)); END;

**Output:**

0.9589242746631384688931544061559939733579

**Example-5:** Using SIN function with select query and returning the value in degrees.

select (SIN(5)) * 57.29 FROM dual;

**Output:**

-54.9367716954512

Using the conversion formula of 1 radian = 57.29 degrees.

**Advantages:**

The SIN function accepts any numeric datatype as well as any non-numeric datatype as an argument that can be implicitly converted to a numeric datatype.

## Recommended Posts:

- PLSQL | LOG Function
- PLSQL | INSTR Function
- PLSQL | INSTRB Function
- PLSQL | LENGTH2 Function
- PLSQL | SOUNDEX Function
- PLSQL | ASCII Function
- PLSQL | CONCAT Function
- PLSQL | COMPOSE Function
- PLSQL | CHR Function
- PLSQL | ASCIISTR Function
- PLSQL | CONVERT Function
- PLSQL | DECOMPOSE Function
- PLSQL | DUMP Function
- PLSQL | INITCAP Function
- PLSQL | LENGTHC Function
- PLSQL | LENGTHB Function
- PLSQL | LENGTH4 Function
- PLSQL | LENGTH Function
- PLSQL | LPAD Function
- PLSQL | INSTRC Function

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.