POWER is one of the vital Numeric/Math functions of Oracle. It is used to get the value of x raised to yth power. The POWER function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.
Syntax:
POWER ( x, y )
Parameters: x, y: They are used to specify the numbers to be used for calculation.
Example 1:
POWER (10, 2) |
Output:
100
Explanation: The POWER is calculated as 10 raised to power 2 which equals to 100.
Example 2:
POWER (1.2, 3) |
Output:
1.728
Explanation: The POWER is calculated as 1.2 raised to power 3 which equals to 1.728.
Example 3:
POWER (-10, 3) |
Output:
-1000
Explanation: The POWER is calculated as -10 raised to power 3 which equals to -1000.
