POWER Function In Oracle
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.
POWER ( x, y )
x, y: They are used to specify the numbers to be used for calculation.
POWER (10, 2)
The POWER is calculated as 10 raised to power 2 which equals to 100.
POWER (1.2, 3)
The POWER is calculated as 1.2 raised to power 3 which equals to 1.728.
POWER (-10, 3)
The POWER is calculated as -10 raised to power 3 which equals to -1000.