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
|
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
|
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.
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!
RELATED POSTS
AI-Powered Retail Growth: How Enteros Aligns Database Performance with RevOps Efficiency
- 22 December 2025
- Database Performance Management
Introduction The retail sector is experiencing a profound digital shift. Omnichannel commerce, hyper-personalized customer experiences, dynamic pricing, real-time inventory visibility, and rapid fulfillment have become the standard rather than the exception. Behind every seamless customer interaction lies a complex technology ecosystem powered by databases, cloud infrastructure, SaaS platforms, analytics engines, and AI-driven applications. As retail … Continue reading “AI-Powered Retail Growth: How Enteros Aligns Database Performance with RevOps Efficiency”
Modernizing Banking IT: How Enteros Combines Database Performance Management, AIOps, and Cloud FinOps
Introduction The banking sector is undergoing one of the most significant technology transformations in its history. Digital banking platforms, real-time payments, mobile apps, AI-driven fraud detection, open banking APIs, and regulatory reporting systems now operate at massive scale and speed. At the heart of all these capabilities lies a complex web of databases and cloud … Continue reading “Modernizing Banking IT: How Enteros Combines Database Performance Management, AIOps, and Cloud FinOps”
Intelligent Healthcare IT Economics: How Enteros Unifies Cost Attribution, Performance Management, and Cloud FinOps with AIOps
- 21 December 2025
- Database Performance Management
Introduction Healthcare organizations today are under immense pressure to deliver better patient outcomes while managing rising operational costs, complex regulatory requirements, and rapidly expanding digital ecosystems. From electronic health records (EHRs) and clinical decision systems to telehealth platforms, AI-driven diagnostics, and revenue cycle applications, healthcare IT environments have become both mission-critical and highly complex. At … Continue reading “Intelligent Healthcare IT Economics: How Enteros Unifies Cost Attribution, Performance Management, and Cloud FinOps with AIOps”
Smart Real Estate IT Operations: How Enteros Uses AIOps to Optimize Database Performance and Cost Estimation
Introduction The real estate sector is undergoing a profound digital transformation. What was once a traditionally asset-heavy, manually operated industry is now driven by data, cloud platforms, and real-time analytics. From property management systems and leasing platforms to smart building technologies, digital twin models, and AI-powered valuation engines, modern real estate enterprises rely heavily on … Continue reading “Smart Real Estate IT Operations: How Enteros Uses AIOps to Optimize Database Performance and Cost Estimation”