LOG
LOG(m,n)

Returns the base m logarithm of the number n.

Parameters

m

Specifies a positive number other than or 1 that represents the logarithm base.

n

Specifies a number, which must be positive, for which you want the base m logarithm.

Example

SQL> SELECT LOG(10,10000) FROM dual;

LOG(10,10000)
-------------
            4

Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.