Purpose
You can call this function to return the value of the constant e (the base of natural logarithms) raised to the power defined by numeric_expression, where e = 2.71828183....
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