Oracle Number Function - Oracle/PLSQL LOG Function






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

The Oracle/PLSQL LOG function returns the logarithm of n base m.

LOG(x, y) returns the logarithm, base x, of y.

Syntax

The syntax for the Oracle/PLSQL LOG function is:

LOG( m, n )

m must be a positive number, except 0 or 1.

n must be a positive number.

Example

In the following example, we are taking the log of 2, base value. 


SQL> select log(2,8) from dual;

  LOG(2,8)
----------
         3

SQL>