«Back to Home

Oracle Jump Start
Topics

How To Use ATAN Function In OraclePLSQL

Description
 
ATAN function returns the arc tangent of n, where n represents the number. This is the numeric Math function in Oracle/PLSQL.
This function can be in an unbounded range and this function returns a value in the range of
-pi/2 to pi/2, expressed in radians.
 
Syntax
The syntax of ATAN function in Oracle/PLSQL is given below-
  1. ATAN (Number)  
Example
  1. Select ATAN (1/2)  
  2. from Dual;  
1

Let’s take another example of ATAN function.
 
Example
  1. Select ATAN (1)  
  2. from Dual;  
2

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

Example
  1. Select ATAN (-3)  
  2. from Dual;  
4

Example
 
  1. Select ATAN (3/2)  
  2. from Dual;  
5

Summary
 
Thus we learnt, ATAN function returns the arc tangent of n, where n represents the number. We learnt, how to use these functions in Oracle with the examples.