PLSQL | EXP Function

The EXP is an inbuilt function in PLSQL which is used to return a value which is e raised to the nth power. Here "e" is a mathematical constant whose value is 2.7182818 and n is the input number. Syntax:

exp(number)

Parameters Used: Here the parameter number is the input number which is raised to the power of "e". Return Value: This function returns a value which is e raised to the nth power. where n is the given input number. Supported Versions of Oracle/PLSQL:

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

Let's see some examples which illustrate the EXP function: Example-1:

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

Output:

20.0855369231877

In the above example, 3 is taken as the parameter which is raised to e. And then it gives a result of 20.0855369231877 Example-2:

DECLARE 
   Test_Number number := 3.1;
   
BEGIN 
   dbms_output.put_line(EXP(Test_Number number)); 
   
END;  

Output:

22.1979512814416

In the above example, 3.1 is taken as the parameter which is raised to e. And then it gives a result of 22.1979512814416 Example-3:

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

Output:

0.0497870683678639

In the above example, -3 is taken as the parameter which is raised to e. And then it gives a result of 0.0497870683678639 Advantage: This function is used to find out a value which is e raised to the nth power. Here "e" is a mathematical constant whose value is 2.7182818 and n is the input number.