ACOS Function in Oracle SQL – PLSQL

The ACOS function in Oracle SQL / PLSQL is used to get arc cosine of a number.

Syntax for the ACOS function in Oracle SQL / PLSQL is:

SELECT ACOS(N)
FROM table_name;

N is the number whose arc cosine is to be determined.

Example 1:

SELECT ACOS(0.4)
FROM DUAL;

Will return “1.15927948072741”


Example 2:

SELECT ACOS(0)
 FROM DUAL;

Will return “1.5707963267949”


Example 3:

SELECT ACOS(-0.4)
 FROM DUAL;

Will return “1.98231317286238”


Tagged , , , , , , , , , , , . Bookmark the permalink.