http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FNumerical_Math_Functions%2FLN
Oracle PL/SQL Tutorial/Numerical Math Functions/LN - История изменений
2026-04-04T09:49:59Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Numerical_Math_Functions/LN&diff=4203&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:46Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Numerical_Math_Functions/LN&diff=4204&oldid=prev
Admin: 1 версия
2010-05-26T10:08:55Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== select ln(32)==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL><br />
SQL><br />
SQL> select ln(32)<br />
2 from dual;<br />
LN(32)<br />
----------<br />
3.4657359<br />
SQL><br />
SQL></source><br />
<br />
<br />
<br />
== SIN(30*3.14159ANH(EXP(4) LOG(LN(32)==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL><br />
SQL> select sin(30*3.14159265/180), tanh(0.5)<br />
2 , exp(4), log(2,32), ln(32)<br />
3 from dual;<br />
SIN(30*3.14159265/180) TANH(0.5) EXP(4) LOG(2,32) LN(32)<br />
---------------------- ---------- ---------- ---------- ----------<br />
.499999999 .462117157 54.59815 5 3.4657359<br />
SQL></source><br />
<br />
<br />
<br />
== Using the LN function==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL> -- create demo table<br />
SQL> create table myTable(<br />
2 id NUMBER(2),<br />
3 value NUMBER(6,2)<br />
4 )<br />
5 /<br />
Table created.<br />
SQL><br />
SQL> -- prepare data<br />
SQL> insert into myTable(ID, value)values (1,9)<br />
2 /<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (2,2.11)<br />
2 /<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (3,3.44)<br />
2 /<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (5,10)<br />
2 /<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (6,3)<br />
2 /<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (8,123.45)<br />
2 /<br />
1 row created.<br />
SQL> insert into myTable(ID, value)values (9,98.23)<br />
2 /<br />
1 row created.<br />
SQL><br />
SQL> select * from myTable<br />
2 /<br />
ID VALUE<br />
---------- ----------<br />
1 9<br />
2 2.11<br />
3 3.44<br />
5 10<br />
6 3<br />
8 123.45<br />
9 98.23<br />
7 rows selected.<br />
SQL><br />
SQL><br />
SQL><br />
SQL> SELECT LN(value) FROM myTable<br />
2 /<br />
LN(VALUE)<br />
----------<br />
2.19722458<br />
.746687947<br />
1.23547147<br />
2.30258509<br />
1.09861229<br />
4.81583622<br />
4.58731167<br />
7 rows selected.<br />
SQL><br />
SQL><br />
SQL><br />
SQL><br />
SQL> -- clean the table<br />
SQL> drop table myTable<br />
2 /<br />
Table dropped.<br />
SQL></source></div>
Admin