All Products
Search
Document Center

EXP

Last Updated: Jun 18, 2021

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 |
+-------------------------------------------+