Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

PLSQL | SQRT Function

  • Last Updated : 18 Oct, 2019

The SQRT function is an inbuilt function in PLSQL which is used to return the square root of the given input number.

Syntax:

Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.

SQRT( number )

Parameters Used:
This function accepts a parameters which are illustrated below:

number – This is the input number whose square root is going to be calculated.



Return Value:
This function returns a numeric number which is square root of the given input number.

Supported Versions of Oracle/PLSQL is given below:

  1. Oracle 12c
  2. Oracle 11g
  3. Oracle 10g
  4. Oracle 9i
  5. Oracle 8i

Let’s see some examples which illustrate the SQRT function:

Example-1:

DECLARE 
   Test_Number number := 25;
   
BEGIN 
   dbms_output.put_line(SQRT(Test_Number number)); 
   
END; 

Output:

5

In the above example, 5 is the square root of 25.

Example-2:

DECLARE 
   Test_Number number := 5.617;
   
BEGIN 
   dbms_output.put_line(SQRT(Test_Number number)); 
   
END; 

Output:

2.37002109695251

In the above example, 2.37002109695251 is the square root of 5.617

Example-3:

DECLARE 
   Test_Number number := 9;
   
BEGIN 
   dbms_output.put_line(SQRT(Test_Number number)); 
   
END; 

Output:

3

In the above example, 3 is the square root of 9

Advantage:
This function is used to calculate the square root of the given input number.

My Personal Notes arrow_drop_up
Recommended Articles
Page :