ACOS

The ACOS function returns the arc cosine of Expression.

SQL syntax

ACOS(Expression)

Parameters

ACOS has the parameter:

Parameter Description

Expression

Operand or column can be any numeric data type or any non-numeric data type that can be implicitly converted to a numeric data type.

Description

  • Expression must be in the range of -1 to 1. ACOS returns a value in the range of 0 to pi, expressed in radians.

  • If Expression is of type NUMBER, the data type returned is NUMBER. For all other numeric data types, the data type returned is BINARY_DOUBLE.

  • If the value of Expression is NULL, NULL is returned.

Example

Use the ACOS function to return the arc cosine of .3. 

Command> SELECT ACOS(.3) "Arc cosine of .3" FROM dual;
< 1.2661036727794991112593187304122222822 >
1 row found.