SIN

The SIN function returns the sine of Expression (an angle expressed in radians).

SQL syntax

SIN(Expression)

Parameters

SIN has the parameter:

Parameter Description

Expression

Operand or column can be any numeric data type or any non-numeric data type that can be implicitly converted to a numeric data type.

Description

  • If Expression is of type NUMBER, the data type returned is NUMBER. For all other numeric data types, the data type returned is BINARY_DOUBLE.

  • If the value of Expression is NULL, NULL is returned.

Example

Use the SIN function to return the sine of 30 degrees. 

Command> SELECT SIN(30 * 3.14159265359/180) FROM dual;
< .5000000000000298434573127255848979959561 >
1 row found.