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”