Oracle / PLSQL: ATAN2 Function

This article is written about how to use the Oracle/PLSQL ATAN2 function with syntax and examples.


The Oracle/PLSQL ATAN2 function returns the arc tangent of n and m.


The syntax for the ATAN2 function in Oracle/PLSQL is:

ATAN2( n, m )

Parameters or Arguments

n and m

The numbers used to calculate the arc tangent.


The ATAN2 function returns a numeric value.

Applies To

The ATAN2 function can be used in the following versions of Oracle/PLSQL:

Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i


Let’s look at some Oracle ATAN2 function examples and explore how to use the ATAN2 function in Oracle/PLSQL.

For example:

ATAN2(0.2, 0.3)
Result: 0.588002603547568

ATAN2(0.35, -0.15)
Result: 1.97568811307998

ATAN2(-0.3, -0.4)
Result: -2.49809154479651