Oracle SQL: the Essential Reference

POWER

POWER(m,n)

Raises m to the power of n. In other words, this function returns mⁿ.

Parameters

m

Specifies a nonzero number.

n

Specifies a power. If m is positive, n may be any positive or negative number. If m is negative, n must be an integer.

Example

SQL> SELECT POWER(10,3), POWER(-10,-3), POWER(-10,3) 
  2  FROM dual;

POWER(10,3) POWER(-10,-3) POWER(-10,3)
----------- ------------- ------------
       1000         -.001        -1000

m-n is equivalent to 1/mn.