Mega Code Archive

 

Categories / Oracle PLSQL / Numeric Math Functions

 

ATAN() and ATAN2() functions are return some the arctangent

SQL> Syntax: ATAN(<numeric expression>) ATAN2(<numeric expression1>,<numeric expression2>) SQL> SQL> SQL> SQL> SELECT    ATAN(.5) AS FIRST_RESULT,   2     ATAN2(.5,1.0) AS SECOND_RESULT   3  FROM DUAL; FIRST_RESULT SECOND_RESULT ------------ -------------   .463647609    .463647609