LN

Purpose

The function returns the natural logarithm of numeric_expression with base e.

Syntax

LN (numeric_expression)

Parameters

numeric_expression is a numeric data type (NUMBER, FLOAT, BINARY_FLOAT, or BINARY_DOUBLE) greater than 0, or an argument that can be implicitly converted to a numeric data type.

Return type

If the parameter is of the BINARY_FLOAT data type, the return type is BINARY_DOUBLE. Otherwise, the return type is the same as the data type of the numeric_expression parameter.

Examples

Return the natural logarithm of 9.

obclient> SELECT LN(9) FROM DUAL;
+------------------------------------------+
| LN(9)                                    |
+------------------------------------------+
| 2.19722457733621938279049047384505140929 |
+------------------------------------------+
1 row in set