Power – Oracle SQL Function

POWER returns the first argument raised to the power of the second.

The arguments can be a numeric value or any type that can be implicitly converted to a number.

Using POWER is a good way of turning a LOG number back into a decimal number.

Syntax:

POWER(n,n2)

Example:

SELECT POWER(2,2) as power_value from dual;

POWER_VALUE
————————-
4