Purpose
EXP() returns the value of the constant e (the base of the natural logarithm, which equals to 2.71828183...) raised to the power defined by numeric_expression.
Syntax
EXP (numeric_expression)
Parameters
numeric_expression is of a numeric data type, such as NUMBER, FLOAT, BINARY_FLOAT, or BINARY_DOUBLE, or any data type that can be implicitly converted to a numeric data type.
Return type
When the parameter is of the BINARY_FLOAT data type, the return type is BINARY_DOUBLE. Otherwise, the return type is the same as the data type of numeric_expression.
Examples
The following example returns the values of e raised to the power of 4 and e raised to the power of 3+2.5.
obclient> SELECT EXP(4),EXP(3+2.5) FROM DUAL;
+-------------------------------------------+------------------------------------------+
| EXP(4) | EXP(3+2.5) |
+-------------------------------------------+------------------------------------------+
| 54.59815003314423907811026120286087840279 | 244.691932264220387915188949511839350184 |
+-------------------------------------------+------------------------------------------+
1 row in set