Oracle SQRT() function
Description
This function is used to get the square root of a given non-negative number.
Uses of Oracle SQRT() Function
- Calculate the square root of a positive number: Obtain the square root value for various mathematical and engineering computations.
- Perform geometric calculations: Utilize the function in geometry for calculations involving the lengths of sides in right-angled triangles.
- Graphing and plotting: Generate graphs and plots that require square root calculations.
- Scientific computations: Conduct scientific research and analyses that involve square root operations.
- Data analysis: Analyze data sets where square root transformations are needed for normalization or other purposes.
Syntax:
SQRT(X)
Where X is a number
Pictorial Presentation of SQRT() function
Example: SQRT() function
SELECT SQRT(25) FROM dual;
Here is the result.
SQRT(25)
----------
5
The above statement will return the square root of the given number 25.
Example: SQRT() function using negative value
SELECT SQRT(-25) FROM dual;
Here is the result.
SELECT SQRT(-25) FROM dual
*
ERROR at line 1:
ORA-01428: argument '-25' is out of range
The above statement will return an error message because the value of the argument (-25) is negative.