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