SQRT returns the square root of
This function takes as an argument any numeric datatype or any nonnumeric datatype that can be implicitly converted to a numeric datatype. The function returns the same datatype as the numeric datatype of the argument.
See Also:Table 2-10, "Implicit Type Conversion Matrix" 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