Open In App

PLSQL | SQRT Function

Improve
Improve
Like Article
Like
Save
Share
Report

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

Syntax:

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.


Last Updated : 18 Oct, 2019
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads