Purpose
You can call this function to calculate the arc sine. 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