Oracle SQL - Function POWER function

Introduction

POWER - Returns value raised to some exponential power.

The POWER function requires two arguments.

The first argument is the value to raise to power, and the second argument is the power (exponent) that you would like the number raised to.

Demo

SQL>
SQL> drop table my_table;

Table dropped.-- w w  w.j a va  2s  .  c  o m

SQL> CREATE TABLE my_table (
  2      LINENO NUMBER(2) not null,
  3      VALUE NUMBER(6,2) not null
  4  );
SQL>
SQL> insert into my_table values(1,1.2);
SQL> insert into my_table values(2,123.34);
SQL> insert into my_table values(3,-12.2);
SQL> insert into my_table values(4,100);
SQL> insert into my_table values(5,48);
SQL> insert into my_table values(6,-90);
SQL> insert into my_table values(7,0.19);
SQL> SELECT POWER(value,2)
  2  FROM my_table ;

POWER(VALUE,2)
--------------
      00001.44
      15212.76
      00148.84
      10000.00
      02304.00
      08100.00
      00000.04

7 rows selected.

SQL>