Oracle - ATAN() Function
The Oracle (PL/SQL) ATAN() function returns arc tangent of a value. The returned value will be in the range -𝜋/2 through 𝜋/2.
Note: ATAN() is the inverse of TAN().
Syntax
ATAN(x)
Parameters
x |
Required. Specify the value. |
Return Value
Returns the arc tangent of the value.
Example 1:
The example below shows the usage of ATAN() function.
ATAN(3) Result: 1.24904577239825442582991707728109012307 ATAN(0.5) Result: .4636476090008061162142562314612144020295 ATAN(0) Result: 0 ATAN(-0.5) Result: -.4636476090008061162142562314612144020295 ATAN(-3) Result: -1.24904577239825442582991707728109012307
Example 2:
Consider a database table called Sample with the following records:
Data | x |
---|---|
Data 1 | -1 |
Data 2 | -0.5 |
Data 3 | 0 |
Data 4 | 0.5 |
Data 5 | 1 |
The statement given below can be used to calculate the arc tangent of records of column x.
SELECT Sample.*, ATAN(x) AS ATAN_Value FROM Sample;
This will produce the result as shown below:
Data | x | ATAN_Value |
---|---|---|
Data 1 | -1 | -.7853981633974483096156608458198757210456 |
Data 2 | -0.5 | -.4636476090008061162142562314612144020295 |
Data 3 | 0 | 0 |
Data 4 | 0.5 | .4636476090008061162142562314612144020295 |
Data 5 | 1 | .7853981633974483096156608458198757210456 |
❮ Oracle Functions