Skip to content
Related Articles

Related Articles

Improve Article

PLSQL | TAN Function

  • Last Updated : 21 Oct, 2019

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.

Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.

My Personal Notes arrow_drop_up
Recommended Articles
Page :