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
(2) Explanation of specification format
- 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.
-
(3) Rules
-
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.
(4) Example
- 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"