EXP function in Oracle

EXP is one of the vital Numeric/Math functions of Oracle. It is used to get the value of the e raised to the nth power. Here e = 2.71828183 and n represents the number passed with the EXP function. The EXP function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.


EXP( number )

Parameters: number: It is used to specify the power to raise e.

Example 1:




Explanation: The value of e raised to the power 5 is 148.41315910258 and so is the result.

Please follow and like us:
Content Protection by DMCA.com