Preamble
The Oracle/PLSQL SQRT function extracts the square root from the number.
Syntax of the Oracle/PLSQL SQRT function
SQRT( number_id )
Parameters and function arguments
- number_id – is a positive number
The SQRT function returns a numeric value.
The SQRT 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 SQRT function and learn how to use the SQRT function in Oracle/PLSQL.
SELECT SQRT(9) FROM DUAL;
--Result: 3
SELECT SQRT(37) FROM DUAL;
--Result: 6,08276253
SELECT SQRT(5.617) FROM DUAL;
--Result: 2.370021096
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
Smarter BFSI Database Operations: How Enteros Applies GenAI to Cloud FinOps and RevOps
- 14 January 2026
- Database Performance Management
Introduction Banks, financial institutions, insurers, and fintech organizations operate in one of the most complex and regulated technology environments in the world. Digital banking platforms, real-time payments, core transaction systems, fraud detection engines, regulatory reporting platforms, and customer engagement channels all depend on highly reliable database operations. As BFSI organizations modernize their technology stacks, database … Continue reading “Smarter BFSI Database Operations: How Enteros Applies GenAI to Cloud FinOps and RevOps”
How Enteros Uses AIOps to Transform Database Performance Management and Cloud FinOps
Introduction As enterprises accelerate cloud adoption, digital transformation has fundamentally reshaped how applications are built, deployed, and scaled. At the center of this transformation lies a critical but often overlooked layer: databases. Every transaction, customer interaction, analytics workflow, and AI model ultimately depends on database performance. Yet for many organizations, database performance management and cloud … Continue reading “How Enteros Uses AIOps to Transform Database Performance Management and Cloud FinOps”
AI-Driven Banking Operations: How Enteros Uses Generative AI and AIOps to Transform Performance
- 13 January 2026
- Database Performance Management
Introduction The banking and financial services industry is operating at a scale and speed never seen before. Digital banking platforms, real-time payments, open banking APIs, AI-powered risk engines, fraud detection systems, and regulatory reporting platforms have become mission-critical. Every customer interaction—from a mobile login to a high-value transaction—depends on complex, always-on technology systems. At the … Continue reading “AI-Driven Banking Operations: How Enteros Uses Generative AI and AIOps to Transform Performance”
From Listings to Leverage: How Enteros Drives Database Performance and FinOps Efficiency in Real Estate
Introduction The real estate industry has rapidly evolved from a traditionally relationship-driven business into a technology-intensive digital ecosystem. Modern real estate enterprises—spanning residential platforms, commercial real estate firms, property management companies, real estate SaaS providers, and proptech startups—are powered by sophisticated technology stacks. Behind online listings, virtual tours, pricing engines, tenant portals, CRM systems, transaction … Continue reading “From Listings to Leverage: How Enteros Drives Database Performance and FinOps Efficiency in Real Estate”