Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The SIN function calculates the sine of an angle expression.
NUMBER
The result returned by SIN is a value with the same dimensions as the specified expression.
SIN(angle-expression)
A numeric expression that contains an angle value, which is specified in radians.
OLADM1896Example 8-98 Calculating the Sine of an Angle in Radians
This example calculates the sine of an angle of 1 radian. The statements
DECIMALS = 5 SHOW SIN(1)
produce the following result.
0.84147
OLADM1897Example 8-99 Calculating the Sine of an Angle in Degrees
This example calculates the sine of an angle of 30 degrees. Since 1
degree = 2*(pi)/360
radians, 30
degrees is about 30*2*3.14159/360
radians. The OLAP DML statement
SHOW SIN(30 * 2 * 3.14159 / 360)
produces the following result.
0.50000