Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 91 of 166
power::=
power
POWER
returns m raised to the nth power. The base m
and the exponent n
can be any numbers, but if m is negative, n must be an integer.
The following example returns 3 squared:
SELECT POWER(3,2) "Raised" FROM DUAL; Raised ---------- 9
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|