Oracle SQRT function.

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

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.​