EXP
The EXP
function returns e
raised to the n
th power (where e
=
2.71828183...
).
SQL syntax
EXP(Expression)
Parameter
EXP
has the parameter:
Parameter | Description |
---|---|
|
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 asExpression
. -
If
Expression
is of typeNUMBER
, the data type returned isNUMBER
. For all other numeric data types, the data type returned isBINARY_DOUBLE
. -
If the value of
Expression
isNULL
,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.