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)


The syntax for the Oracle/PLSQL TAN function is:

TAN( n )

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


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;