http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FPL_SQL_Programming%2FDBMS_RANDOM
Oracle PL/SQL Tutorial/PL SQL Programming/DBMS RANDOM - История изменений
2026-05-24T11:56:41Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/PL_SQL_Programming/DBMS_RANDOM&diff=4017&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/PL_SQL_Programming/DBMS_RANDOM&diff=4018&oldid=prev
Admin: 1 версия
2010-05-26T10:08:21Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== DBMS_RANDOM==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL> v_random_nr:= dbms_random.random;<br />
SQL><br />
SQL> Returns a random integer value in the range of ?^31 to 2^31.<br />
SQL><br />
SQL> declare<br />
2 v2_nr binary_integer:=dbms_random.random;<br />
3 begin<br />
4 DBMS_OUTPUT.put_line("Int:"||v2_nr);<br />
5 end;<br />
6 /<br />
Int:-1254017024<br />
PL/SQL procedure successfully completed.<br />
SQL></source><br />
<br />
<br />
<br />
== v_value_nr:= dbms_random.value[(min, max)];==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL> --Generates a random value between the MINand MAX numbers passed as parameters (between 0 and 1 if parameters are omitted) with 38 digits after the decimal point.<br />
SQL><br />
SQL> declare<br />
2 v1_nr number:=dbms_random.value(10,15);<br />
3 begin<br />
4 DBMS_OUTPUT.put_line("Float:"||v1_nr);<br />
5 end;<br />
6 /<br />
Float:13.1192638925165964762502277715685751274<br />
PL/SQL procedure successfully completed.<br />
SQL></source></div>
Admin