Oracle ACOS function.

Preamble

The Oracle/PLSQL ACOS function returns the number arcosine.

Oracle/PLSQL syntax of the ACOS function

ACOS( number_id )

Parameters and function arguments

• number_id – number to calculate the arcosine.

The ACOS function returns a numeric value.

The ACOS function can be used in the following versions of Oracle/PLSQL

Let’s consider some examples of the ACOS function and learn how to use the ACOS function in Oracle/PLSQL.

SELECT ACOS(0.2) FROM DUAL;

--Result: 1.36943840

SELECT ACOS(0.35) FROM DUAL;

--Result: 1.21322522

SELECT ACOS(-0.15) FROM DUAL;

--Result: 1.721364599

About Enteros

​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.