Oracle PL/SQL/Numeric Math Functions/POWER

POWER(100,0.5): square root

   <source lang="sql">
 

SQL> SQL> SELECT

 2  POWER(100, 1)  power_1,
 3  POWER(100,0.5) square_root,
 4  POWER(100,-2)  one_ten_thousandth from dual;
  POWER_1 SQUARE_ROOT ONE_TEN_THOUSANDTH

---

----------- ------------------

      100          10              .0001
  
 </source>
   
  

POWER(2, 3)

   <source lang="sql">

SQL> select POWER(2, 3) from dual; POWER(2,3)

---

        8

SQL>

 </source>
   
  

POWER(2,3) POWER(-OD(OD(13,0)

   <source lang="sql">

SQL> SQL> select power(2,3), power(-2,3)

 2  ,        mod(8,3),   mod(13,0)
 3  from   dual;

POWER(2,3) POWER(-2,3) MOD(8,3) MOD(13,0)

---

----------- ---------- ----------

        8          -8          2         13

SQL>

 </source>
   
  

POWER: Returns value raised to some exponential power

   <source lang="sql">

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("1","Alison",to_date("19970622","YYYYMMDD"),-12.12); 1 row created. SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values("1","Alison",to_date("19980513","YYYYMMDD"),22.1); 1 row created. SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values("1","Alison",to_date("19990624","YYYYMMDD"),-2.12); 1 row created. SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values("1","Alison",to_date("20000415","YYYYMMDD"),2.1); 1 row created. SQL> SQL> SQL> select * from TestTable

 2

SQL> SQL> --POWER: Returns value raised to some exponential power SQL> SQL> SQL> SELECT POWER(MyNumber,2) FROM TestTable; POWER(MYNUMBER,2)

---

        146.8944
        146.8944
          488.41
          4.4944
            4.41

SQL> SQL> drop table TestTable; Table dropped. SQL>

 </source>
   
  

POWER(x, y): Returns the result of x raised to the power y

   <source lang="sql">

SQL> --POWER(x, y): Returns the result of x raised to the power y. SQL> SQL> select POWER(2, 1) from dual; POWER(2,1)

---

        2

SQL>

 </source>
   
  

select power(7 ) "With Reals"

   <source lang="sql">
 

SQL> SQL> SQL> select power( 5.2, 2.7 ) "With Reals"

 2      from dual
 3    /

With Reals

---

85.7450441 1 row selected. SQL> SQL> --

 </source>
   
  

select power( "Using Negatives"

   <source lang="sql">
 

SQL> SQL> SQL> select power( -5, 3 ) "Using Negatives"

 2      from dual
 3    /

Using Negatives

---

          -125

1 row selected. SQL> --

 </source>