Oracle POWER function.

Preamble

The Oracle/PLSQL POWER function elevates m to degree n.

Oracle/PLSQL syntax of the POWER function

POWER( m, n )

Parameters or arguments

• m – is the base.
• n – is an indicator.

1. The POWER function returns a numeric value.
2. If m is negative, then n must be an integer.

The POWER function can be used in the following versions of Oracle/PLSQL

Let’s consider some examples of the POWER function and learn how to use the POWER function in Oracle/PLSQL.

SELECT POWER(3, 2) FROM DUAL;

--Result: 9

SELECT POWER(5, 3) FROM DUAL;

--Result: 125

SELECT POWER(-5, 3) FROM DUAL;

--Result: -125

SELECT POWER(6.2, 3) FROM DUAL;

--Result: 238,328

SELECT POWER(6.2, 3.5) FROM DUAL;

--Result: 593.4319342778

About Enteros

​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.