2.计算一下2的倒数(也就是2的-1次幂)
sys@ora10g> select power(2,-1) from dual;POWER(2,-1)
-----------
.5
3.POWER函数语法
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions112.htm#SQLRF00689
非常简单:
POWER(n2, n1)
返回n2的n1次方结果。
4.延伸一下,在操作系统中计算幂的方法。
我们来使用Linux操作系统的bc命令计算幂,看一下效果。
ora10g@secDB /home/oracle$ bc
bc 1.06
Copyright 1991-1994, 1997, 1998, 2000 Free Software Foundation, Inc.
This is free software with ABSOLUTELY NO WARRANTY.
For details type `warranty'.
2^22
4194304
3^3
27