All Products
Search
Document Center

POWER

Last Updated: Jun 18, 2021

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 |
+------------+--------------+--------------+