Purpose
ASIN() returns the arc sine of a number. The arc sine is an angle whose sine is a number. The returned angle is given in radians, in the range of [-π/2, π/2].
Syntax
ASIN(number)
Parameters
number falls in the range of [-1, 1], and is of a numeric data type or any data type that can be implicitly converted to a numeric data type.
Return type
The return type is NUMBER.
Examples
The following example returns the arc sine of 0.5.
obclient> SELECT ASIN(0.5) FROM DUAL;
+-------------------------------------------+
| ASIN(0.5) |
+-------------------------------------------+
| .5235987755982988730771072305465838140329 |
+-------------------------------------------+
1 row in set