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
How to Modernize Healthcare Cost Management with Enteros Database Software and Performance Intelligence
- 25 June 2026
- Software Engineering
Introduction Healthcare organizations are undergoing a major digital transformation driven by electronic health records (EHR), telemedicine platforms, AI-powered diagnostics, and cloud-based clinical systems. While these technologies improve patient care and operational efficiency, they also introduce significant financial and infrastructure challenges. Modern healthcare ecosystems now include: Electronic Health Record (EHR) systems Hospital Information Systems (HIS) Laboratory … Continue reading “How to Modernize Healthcare Cost Management with Enteros Database Software and Performance Intelligence”
How to Reduce Healthcare IT Costs with Enteros Database Performance Management and Cost Estimation
Introduction The healthcare industry is under continuous pressure to deliver high-quality patient care while simultaneously reducing operational and IT infrastructure costs. Hospitals, clinics, diagnostic centers, and digital health platforms are rapidly adopting cloud systems, AI-driven diagnostics, and electronic health records (EHR) to improve efficiency and patient outcomes. Modern healthcare ecosystems now rely on: Electronic Health … Continue reading “How to Reduce Healthcare IT Costs with Enteros Database Performance Management and Cost Estimation”
How Real-Time Database Intelligence Prevents Performance Regressions
In today’s digital-first business environment, application performance directly influences customer satisfaction, operational efficiency, and revenue growth. Users expect applications to be fast, reliable, and always available—whether they are completing transactions, accessing dashboards, processing payments, or interacting with enterprise software. Even minor performance slowdowns can negatively impact user experience and business outcomes. One of the most … Continue reading “How Real-Time Database Intelligence Prevents Performance Regressions”
The Role of Database Observability in Accelerating DevOps and CI/CD Pipelines
In today’s fast-paced digital landscape, speed of innovation is a major competitive advantage. Enterprises are under constant pressure to release new features, deploy updates faster, fix issues quickly, and maintain highly reliable digital services. This demand has fueled the widespread adoption of DevOps practices and CI/CD (Continuous Integration and Continuous Delivery) pipelines. DevOps and CI/CD … Continue reading “The Role of Database Observability in Accelerating DevOps and CI/CD Pipelines”