The POWER function returns x that is raised to the y power.
Syntax
POWER (x, y)
Parameters
| Parameter | Description |
|---|---|
| x,y | x and y are the expressions of the numeric types: NUMBER, FLOAT, BINARY_FLOAT, and BINARY_DOUBLE. |
Return type
If the data types of the parameters are BINARY_FLOAT and BINARY_DOUBLE, the return type is BINARY_DOUBLE. In other cases, the return type is NUMBER.
Examples
This example shows the results of using the POWER function for three different groups of numbers.
Execute the following statement:
SELECT POWER(2,2), POWER(1.5,0), POWER(20, -1) FROM DUAL;
The following query result is returned:
+------------+--------------+--------------+
| POWER(2,2) | POWER(1.5,0) | POWER(20,-1) |
+------------+--------------+--------------+
| 4 | 1 | .05 |
+------------+--------------+--------------+