EXP

The EXP function returns e raised to the nth power (where e = 2.71828183...).

SQL syntax

EXP(Expression)

Parameter

EXP has the parameter:

Parameter Description

Expression

Operand or column can be any numeric data type or any non-numeric data type that can be implicitly converted to a numeric data type.

Description

  • EXP returns a value of the same type as Expression.

  • If Expression is of type NUMBER, the data type returned is NUMBER. For all other numeric data types, the data type returned is BINARY_DOUBLE.

  • If the value of Expression is NULL, NULL is returned.

Example

Use the EXP function to return e to the fourth power.

Command> SELECT EXP(4) "e to the 4th power" FROM dual;
< 54.59815003314423907811026120286087840308 >
1 row found.