Purpose
This function returns the square root of the numeric_expression argument.
Syntax
SQRT(numeric_expression)
Parameters
numeric_expression is an argument of a numeric data type (NUMBER, FLOAT, BINARY_FLOAT, and BINARY_DOUBLE) or an argument that can be implicitly converted to a numeric data type and is greater than or equal to zero.
Return type
The return type is the same as the data type of the numeric_expression argument.
Examples
Calculate the square roots of 64 and 50+50.
obclient> SELECT SQRT(64),SQRT(50+50) FROM DUAL;
+----------+-------------+
| SQRT(64) | SQRT(50+50) |
+----------+-------------+
| 8 | 10 |
+----------+-------------+
1 row in set