SQRT returns the square root of
This function takes as an argument any numeric data type or any nonnumeric data type that can be implicitly converted to a numeric data type. The function returns the same data type as the numeric data type of the argument.
Table 2-8 for more information on implicit conversion
n resolves to a
NUMBER, then the value
n cannot be negative.
SQRT returns a real number.
n resolves to a binary floating-point number (
n >= 0, then the result is positive.
n = -0, then the result is -0.
n < 0, then the result is
The following example returns the square root of 26:
SELECT SQRT(26) "Square root" FROM DUAL; Square root ----------- 5.09901951