Oracle/PLSQL: Log Function

In Oracle/PLSQL, the log function returns the logarithm of n base m.

Syntax

The syntax for the log function is:

log( m, n )

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

n must be a positive number.

Applies To

• Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

For Example

log(10, 20)	would return 1.30102999566398
log(2, 15)	would return 3.90689059560852
log(100, 1)	would return 0