Purpose
The EXP function returns the exponential value of the numeric_expression parameter, where the base of the exponentiation is the natural constant e (e = 2.71828183...).
Syntax
EXP (numeric_expression)
Parameters
numeric_expression is a parameter of a numeric data type (NUMBER, FLOAT, BINARY_FLOAT, or BINARY_DOUBLE) or a parameter that can be implicitly converted to a numeric data type.
Return type
If the numeric_expression 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 the numeric_expression parameter.
Examples
Return the exponential value of 4 and the exponential value 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