Oracle POWER

Posted on 11/19/2011 by admin

Function Description

Function POWER returns x raised to the y power. If argument x is negative then
argument x MUST be an integer.

Examples

SELECT POWER(2, 2)
  FROM dual;

Result: 4

SELECT POWER(-2, 3)
  FROM dual;

Result: -8

SELECT POWER(2, 3.5)
  FROM dual;

Result: 11,3137084989848

SELECT POWER(2, 2)

FROM dual;

Result: 4

SELECT POWER(-2, 3)

FROM dual;

Result: -8

SELECT POWER(2, 3.5)

FROM dual;

Result: 11,3137084989848

This entry was posted in Oracle SQL Functions. Bookmark the permalink.