CodesJava

Easy learning with example program codes

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.

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.

Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status