Oracle Number Function - Oracle/PLSQL TAN Function






This Oracle tutorial explains how to use the Oracle/PLSQL TAN function.

The Oracle/PLSQL TAN function returns the tangent of n.

TAN returns the tangent of a value. The TAN function take arguments in radians where:

radians = (angle * 2 * 3.1416 / 360)

Syntax

The syntax for the Oracle/PLSQL TAN function is:

TAN( n )

n is a number. It is an angle expressed in radians.

Example


select TAN(3.1415) from dual;

Using TAN function to find the tangent of 30 degrees: 


SQL> select TAN(30*2*3.1415926/360) From dual;

TAN(30*2*3.1415926/360)
-----------------------
             .577350257

SQL>