Quick Search:
 
 The Oracle PL/SQL SQRT Function      [Return To Index] Jump to:  

Term: SQRT

Definition:
In Oracle PL/SQL, SQRT is a built in function which returns the square root of a numeric input. It returns positive output if the input argument is a number. For negative input arguments, it raises ORA-01428 exception.

Example Syntax:

SQRT(x)


Example Usage:

The SQL below shows that SQRT function raises exception when used with negative number.

SQL> select sqrt(-3) from dual;
select sqrt(-3) from dual
*
ERROR at line 1:
ORA-01428: argument '-3' is out of range


The SQL statement below returns the square root of 3.

SQL> SELECT SQRT(3) FROM DUAL;

SQRT(3)
----------
1.73205081



Related Links:
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org