The EXP function returns e that is raised to the power of numeric_expression. e is a mathematical constant and is equal to 2.71828183....
Syntax
EXP (numeric_expression)
Parameters
| Parameter | Description |
|---|---|
| numeric_expression | The expression of the exact numeric data types or the approximate numeric data types: NUMBER, FLOAT, BINARY_FLOAT, and BINARY_DOUBLE. |
Return type
The return type is the same as the data type of the numeric_expression parameter.
Examples
This example shows the result of querying e that is raised to the power of 4.
Execute the following statement:
SELECT EXP(4) "e to the 4th power" FROM DUAL;
The following query result is returned:
+-------------------------------------------+
| e to the 4th power |
+-------------------------------------------+
| 54.59815003314423907811026120286087840279 |
+-------------------------------------------+