PLSQL | TAN Function

The TAN function is an inbuilt function in PLSQL which is used to return the tangent of an input number. The tangent is a trigonometric function of an angle and here the input number is the angle expressed in the form of radians. 180 degree is equal to pi radian.

Syntax:

TAN( number )

Parameters Used:
This function accepts a parameters which are illustrated below:

number – This is the input number which is an angle expressed in Radian.

Return Value:
This function returns a numeric value which is tangent of that input angle.

Supported Versions of Oracle/PLSQL is given below:

1. Oracle 12c
2. Oracle 11g
3. Oracle 10g
4. Oracle 9i
5. Oracle 8i

Let’s see some examples which illustrate the TAN function:

Example-1:

DECLARE 
   Test_Number number := 3;
   
BEGIN 
   dbms_output.put_line(TAN(Test_Number number)); 
   
END; 

Output:

-0.142546543074278

In the above example, tangent of 3 is -0.142546543074278

Example-2:

DECLARE 
   Test_Number number := 5.2;
   
BEGIN 
   dbms_output.put_line(TAN(Test_Number number)); 
   
END; 

Output:

-1.88564187751976

In the above example, the tangent of 5.2 is -1.88564187751976

Example-3:

DECLARE 
   Test_Number number := -5.2;
   
BEGIN 
   dbms_output.put_line(TAN(Test_Number number)); 
   
END; 

Output:

1.88564187751976

In the above example, the tangent of -5.2 is 1.88564187751976

Advantage:
This function is used to calculate the tangent of a input number.