LN

The LN function returns the natural logarithm of Expression, where the value of Expression is greater than 0.

SQL syntax

LN(Expression)

Parameters

LN 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

  • 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 LN function to return the natural logarithm of 95. 

Command> SELECT LN(95) "Natural logarithm of 95" FROM dual;
< 4.55387689160054083460978676511404117675 >
1 row found.