POWER |
POWER(m,n) |
Raises m to the power of n. In other words, this function returns mn.
Parameters
m
Specifies a nonzero number.
n
Specifies a power. If m is positive, n may be any positive or negative number. If m is negative, n must be an integer.
Example
SQL> SELECT POWER(10,3), POWER(-10,-3), POWER(-10,3) 2 FROM dual; POWER(10,3) POWER(-10,-3) POWER(-10,3) ----------- ------------- ------------ 1000 -.001 -1000
|
Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.