SQL POWER() Function

SQL POWER() function return n1 raised to a n2 power. n1 is base value and n2 is any numbers.

Supported Oracle SQL Version

Oracle 8i
Oracle 9i
Oracle 10g
Oracle 11g
Oracle 12c
Oracle 18c

Syntax

POWER(n1,n2)

Example

Considering following example SQL POWER() function.

SQL> SELECT POWER(4,2) "POWER" FROM DUAL;

     POWER
----------
        16

SQL> SELECT POWER(4,5) "POWER" FROM DUAL;

     POWER
----------
      1024

SQL> SELECT POWER(4,7) "POWER" FROM DUAL;

     POWER
----------
     16384