Find square root of the number in oracle using SQRT mathematical function
By Santhosh N
This explains how to find square root of the number in oracle using mathematical function, SQRT.
There is a Mathematical function in oracle by the name, SQRT which is used to find the square root of the number.
Syntax: SQRT(n)
Here n is the number that needs to be converted to square root.
Ex1: SELECT SQRT(16) FROM dual;
This returns 4 as result.
Related FAQs
This explains how to find maximum value of the expression in oracle using mathematical function, MAX.
This explains how to find absolute value of the number in oracle using mathematical function, ABS.
This explains how to convert one datatype to other in oracle.
This explains how to convert the string to an interval Year to Month type in oracle.
This explains how to convert LOB value from the national character set to the Database character set.
This explains how to convert a hexadecimal value into a raw value in oracle.
Find square root of the number in oracle using SQRT mathematical function (1340 Views)