Purpose
The function returns the inverse sine of a number. The inverse sine of a number is the angle whose sine is the number. The returned angle is in radians and ranges from [-π/2, π/2].
Syntax
ASIN(number)
Parameters
number is a numeric data type or a parameter that can be implicitly converted to a numeric data type, with a value in the range [-1, 1].
Return type
The function returns a value of the NUMBER data type.
Examples
Return the inverse sine of 0.5.
obclient> SELECT ASIN(0.5) FROM DUAL;
+-------------------------------------------+
| ASIN(0.5) |
+-------------------------------------------+
| .5235987755982988730771072305465838140329 |
+-------------------------------------------+
1 row in set