Oracle Number Function - Oracle/PLSQL LN Function

This Oracle tutorial explains how to use the Oracle/PLSQL LN function.

The Oracle/PLSQL LN function returns the natural logarithm of a number.

LN returns natural logs, that is, logs with respect to base e.

Syntax

The syntax for the Oracle/PLSQL LN function is:

LN( number )

number must be greater than 0.

Example


SQL> select ln(2) from dual;
-- from  ww w.  j a  v  a2  s  . c  o  m
     LN(2)
----------
.693147181

SQL> select LN(2.71828183) from dual;

LN(2.71828183)
--------------
             1

SQL>