«Back to Home

Oracle Jump Start
Topics

How To Use ACOS Function In OraclePLSQL

Description
 
ACOS function returns the arc cosine of n, where n represents the number. This is the numeric Math function in Oracle/PLSQL.
N must be in the range of -1 to 1.
 
This functions returns a value in the range of 0 to pi.
 
Syntax
 
The syntax of ACOS function in Oracle/PLSQL is given below-
  1. ACOS (NUMBER)  
Example
  1. Select ACOS (0.36)  
  2. from Dual;  
1
 
Let’s take another example of ACOS function, which is given below-
 
Example
  1. Select ACOS (-0.36)  
  2. from Dual;  
2

Example
  1. Select ACOS (1)  
  2. from Dual;   
3

Example
  1. Select ACOS (0)  
  2. from Dual;  
4

Summary
 
Thus we learnt, ACOS function returns the arc cosine of n, where n represents the number. This is the numeric Math function in Oracle/PLSQL. We learnt, how to use ACOS function with the examples.