Oracle Number Function - Oracle/PLSQL EXP Function

This Oracle tutorial explains how to use the Oracle/PLSQL EXP function.

EXP returns e raised to a value.

Syntax

The syntax for the Oracle/PLSQL EXP function is:

exp( number )

number is the power to raise e to.

Example


SQL> select exp(3) from dual;
-- from  www  . ja  va  2  s.c  o m
    EXP(3)
----------
20.0855369

SQL> select EXP(1) from dual;

    EXP(1)
----------
2.71828183

SQL> select EXP(2) from dual;

    EXP(2)
----------
 7.3890561

SQL>