Oracle Number Function - Oracle/PLSQL ACOS Function

This Oracle tutorial explains how to use the Oracle/PLSQL ACOS function.

The Oracle/PLSQL ACOS function returns the arc cosine of a number.

Syntax

The syntax for the Oracle/PLSQL ACOS function is:

ACOS( number )

number is the number used to calculate the arc cosine.

Example


SQL> select ACOS(1) from dual;
-- from  w w w. j  av  a  2  s .  c o m
   ACOS(1)
----------
         0

SQL> select ACOS(-1) from dual;

  ACOS(-1)
----------
3.14159265

SQL>
                ACOS(0.2)
-------------------------
         1.36943840600457
 
               ACOS(0.35)
-------------------------
         1.21322522314939
 
              ACOS(-0.15)
-------------------------
         1.72136459957158