LN returns the natural log of the argument.

The argument can be a numeric value or any type that can be implicitly converted to a numeric value.

The function returns a value that is the same type as the numeric argument type unliess the argument is a BINARY_FLOAT. In this case the function returns a BINARY_DOUBLE.


SELECT LN(20) as log_value from dual;


Ln – Oracle SQL Function
Tagged on: