Oracle PL/SQL/Numeric Math Functions/POWER
Содержание
POWER(100,0.5): square root
<source lang="sql">
SQL> SQL> SELECT
2 POWER(100, 1) power_1, 3 POWER(100,0.5) square_root, 4 POWER(100,-2) one_ten_thousandth from dual; POWER_1 SQUARE_ROOT ONE_TEN_THOUSANDTH
----------- ------------------
100 10 .0001 </source>
POWER(2, 3)
<source lang="sql">
SQL> select POWER(2, 3) from dual; POWER(2,3)
8
SQL>
</source>
POWER(2,3) POWER(-OD(OD(13,0)
<source lang="sql">
SQL> SQL> select power(2,3), power(-2,3)
2 , mod(8,3), mod(13,0) 3 from dual;
POWER(2,3) POWER(-2,3) MOD(8,3) MOD(13,0)
----------- ---------- ----------
8 -8 2 13
SQL>
</source>
POWER: Returns value raised to some exponential power
<source lang="sql">
SQL> SQL> -- create demo table SQL> create table TestTable(
2 ID VARCHAR2(4 BYTE) NOT NULL, 3 MyName VARCHAR2(10 BYTE), 4 MyDate DATE, 5 MyNumber Number(8,2) 6 ) 7 /
Table created. SQL> SQL> SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values("1","Alison",to_date("19960711","YYYYMMDD"),12.12); 1 row created. SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values("1","Alison",to_date("19970622","YYYYMMDD"),-12.12); 1 row created. SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values("1","Alison",to_date("19980513","YYYYMMDD"),22.1); 1 row created. SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values("1","Alison",to_date("19990624","YYYYMMDD"),-2.12); 1 row created. SQL> insert into TestTable (ID, MyName, MyDate, MyNumber) values("1","Alison",to_date("20000415","YYYYMMDD"),2.1); 1 row created. SQL> SQL> SQL> select * from TestTable
2
SQL> SQL> --POWER: Returns value raised to some exponential power SQL> SQL> SQL> SELECT POWER(MyNumber,2) FROM TestTable; POWER(MYNUMBER,2)
146.8944 146.8944 488.41 4.4944 4.41
SQL> SQL> drop table TestTable; Table dropped. SQL>
</source>
POWER(x, y): Returns the result of x raised to the power y
<source lang="sql">
SQL> --POWER(x, y): Returns the result of x raised to the power y. SQL> SQL> select POWER(2, 1) from dual; POWER(2,1)
2
SQL>
</source>
select power(7 ) "With Reals"
<source lang="sql">
SQL> SQL> SQL> select power( 5.2, 2.7 ) "With Reals"
2 from dual 3 /
With Reals
85.7450441 1 row selected. SQL> SQL> --
</source>
select power( "Using Negatives"
<source lang="sql">
SQL> SQL> SQL> select power( -5, 3 ) "Using Negatives"
2 from dual 3 /
Using Negatives
-125
1 row selected. SQL> --
</source>