Purpose
TAN() returns the tangent of an angle.
Syntax
TAN(x)
Parameters
x is of a numeric data type whose value can be any real number (an angle expressed in radians), or is of any data type that can be implicitly converted to a numeric data type.
Return type
If x is of the BINARY_FLOAT data type, the return type is BINARY_DOUBLE. Otherwise, the return type is a numeric data type same as that of x.
Examples
The following example returns the tangents of 0 degrees and 135 degrees.
obclient> SELECT TAN(0),TAN(135*3.1415926/180) FROM DUAL;
+--------+-------------------------------------------+
| TAN(0) | TAN(135*3.1415926/180) |
+--------+-------------------------------------------+
| 0 | -1.00000008038469308854331997429109563738 |
+--------+-------------------------------------------+
1 row in set