8.3.1 EXP

Returns the result of raising the base of the natural logarithm to a power.

Organization of this subsection

(1) Specification format

scalar-function-EXP ::= EXP(exponent)
 
  exponent ::= value-expression

exponent:

Specifies the exponent.

The following rules apply:

Specify the exponent in the form of a value expression. For details about value expressions, see 7.20 Value expression.
Specify numeric data for the exponent. For details about numeric data, see (1) Numeric data in 6.2.1 List of data types.
You cannot specify a dynamic parameter by itself for the exponent.

The data type of the execution result is the DOUBLE PRECISION type.
If the execution result cannot be represented in the DOUBLE PRECISION type, an overflow error is generated.
The NOT NULL constraint does not apply to the value of the execution result (the null value is allowed).
If the exponent has a null value, the execution result will be a null value.

Example:

Using the values of columns C1 to C3 in table T1 as the exponents, determine the respective powers of the base of the natural logarithm.

SELECT EXP("C1"),EXP("C2"),EXP("C3") FROM "T1"

[Figure]