The ACOS function returns an angle that is expressed in radians. The cosine of the angle is a specified NUMBER expression. It is also called the arc cosine.
Syntax
ACOS (num_expression)
Parameters
| Parameter | Value | Description |
|---|---|---|
| num_expression | -1.00~1.00 | The expression of the NUMBER type or the types that can be implicitly converted to the NUMBER type. Only the values from -1.00 to 1.00 are valid. For values beyond this range, the function returns NULL and reports an error. |
Return type
NUMBER data type
Examples
This example returns the value of ACOS for the specified number.
Execute the following statement:
SELECT ACOS(0.3)"acos_test" FROM DUAL;
The following query result is returned:
+-----------+
| acos_test |
+-----------+
|1.26610367 |
+-----------+