Get the square root : SQRT « Numeric Math Functions « Oracle PL / SQL






Get the square root

 

SQL>
SQL> -- create demo table
SQL> create table TestTable(
  2    ID                 VARCHAR2(4 BYTE)         NOT NULL,
  3    MyName             VARCHAR2(10 BYTE),
  4    MyDate             DATE,
  5    MyNumber           Number(8,2)
  6  )
  7  /

Table created.

SQL>
SQL>
SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values('1','Alison',to_date('19960711','YYYYMMDD'),12.12);

1 row created.

SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values('3','Smith',to_date('19980513','YYYYMMDD'),22.1);

1 row created.

SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values('5','Darlene',to_date('20000415','YYYYMMDD'),2.1);

1 row created.

SQL>
SQL>
SQL> select * from TestTable;

ID   MYNAME     MYDATE      MYNUMBER
---- ---------- --------- ----------
1    Alison     11-JUL-96      12.12
3    Smith      13-MAY-98       22.1
5    Darlene    15-APR-00        2.1

SQL>
SQL>
SQL> SELECT MyNumber, SQRT(MyNumber) FROM TestTable;

  MYNUMBER SQRT(MYNUMBER)
---------- --------------
     12.12     3.48137904
      22.1     4.70106371
       2.1     1.44913767

SQL>
SQL>
SQL> drop table TestTable;

Table dropped.

SQL>
SQL>

           
         
  








Related examples in the same category

1.SQRT() extracts the square root from the input argument.
2.SQRT(x): Returns the square root of x
3.SQRT(5)
4.round(sqrt(sal),2)