Thursday, 31 March 2016

SQL Sqrt

This will give the square root of the given value.

     Syntax:   
                   sqrt (value)      --  here value must be positive.

     Ex:
          SQL> select sqrt(4), sqrt(0), sqrt(null), sqrt(1) from dual;

                             SQRT(4)    SQRT(0) SQRT(NULL)    SQRT(1)
----------    ---------- ---------------         ----------
         2               0               1                    1

No comments:

Post a Comment