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:**

- Oracle 12c
- Oracle 11g
- Oracle 10g
- Oracle 9i
- 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.

## Recommended Posts:

- PLSQL | MOD Function
- PLSQL | COS Function
- PLSQL | SIN Function
- PLSQL | LOG Function
- PLSQL | CHR Function
- PLSQL | ABS Function
- PLSQL | TAN Function
- PLSQL | LN Function
- PLSQL | LEAST Function
- PLSQL | DUMP Function
- PLSQL | ATAN Function
- PLSQL | LENGTH2 Function
- PLSQL | TRUNC Function
- PLSQL | LENGTHB Function
- PLSQL | LENGTHC Function
- PLSQL | INSTRB Function
- PLSQL | INSTR4 Function
- PLSQL | INITCAP Function
- PLSQL | TRIM Function
- PLSQL | LENGTH4 Function

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.