Oracle LOG function.

Preamble

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

Syntax of the Oracle/PLSQL LOG function

LOG( m, n )

Parameters and arguments

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

The LOG function returns a numeric value.

The LOG function can be used in the following versions of Oracle/PLSQL

Let’s consider some examples of the LOG function and learn how to use the LOG function in Oracle/PLSQL.

SELECT LOG(10, 20) FROM DUAL;

--Result: 1,30102999

SELECT LOG(2, 15) FROM DUAL;

--Result: 3.90689059

SELECT LOG(100, 1) FROM DUAL;

--Result: 0

About Enteros

​​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​