Oracle PL/SQL Programming, Third Edition

Name

POWER

Synopsis

The POWER function raises the first argument to the power indicated by the second argument. The specification for the POWER function is:

FUNCTION POWER (base NUMBER, power NUMBER) RETURN NUMBER;

If base is negative, then power must be an integer. The following expression calculates the range of valid values for a BINARY_INTEGER variable (-2³¹ -1 through 2³¹ -1):

POWER (-2, 31) - 1 .. POWER (2, 31) - 1

or:

-2147483649 .. 2147483647