ATAN Function in Oracle SQL – PLSQL

The ATAN function in Oracle SQL / PLSQL is used to get arc tangent of a number.

Syntax for the ATAN function in Oracle SQL / PLSQL is:

SELECT ATAN(N)
FROM table;

N is the number whose arc tangent is to be determined.

Example 1:

SELECT ATAN(0.4)
FROM DUAL;

Will return “0.380506377112365”


Example 2:

SELECT ATAN(0)
 FROM DUAL;

Will return “0”


Example 3:

SELECT ATAN(-0.4)
 FROM DUAL;

Will return “-0.380506377112365”


Tagged , , , , , , , , , , , . Bookmark the permalink.