Home Privacy Policy Feedback Link to us Site Map
Loading

Oracle/PLSQL: Power Function


In Oracle/PLSQL, the power function returns m raised to the nth power.

The syntax for the power function is:

power( m, n )

m is the base.
n is the exponent.
If m is negative, then n must be an integer.

Applies To:

  • Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

For Example:

power(3, 2) would return 9
power(5, 3) would return 125
power(-5, 3) would return -125
power(6.2, 3) would return 238.328
power(6.2, 3.5) would return 593.431934277892