http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FPL_SQL_Programming%2Fdbms_utility
Oracle PL/SQL Tutorial/PL SQL Programming/dbms utility - История изменений
2026-05-24T02:17:37Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/PL_SQL_Programming/dbms_utility&diff=4023&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_utility&diff=4024&oldid=prev
Admin: 1 версия
2010-05-26T10:08:23Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== dbms_utility.get_time==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL> declare<br />
2 type rc is ref cursor;<br />
3 l_rc rc;<br />
4 l_dummy all_objects.object_name%type;<br />
5 l_start number default dbms_utility.get_time;<br />
6 begin<br />
7 for i in 1 .. 1000<br />
8 loop<br />
9 open l_rc for<br />
10 "select object_name<br />
11 from all_objects<br />
12 where object_id = :x"<br />
13 using i;<br />
14 fetch l_rc into l_dummy;<br />
15 close l_rc;<br />
16 end loop;<br />
17 dbms_output.put_line<br />
18 ( round( (dbms_utility.get_time-l_start)/100, 2 ) ||<br />
19 " seconds..." );<br />
20 end;<br />
21 /<br />
.63 seconds...<br />
PL/SQL procedure successfully completed.<br />
Elapsed: 00:00:00.70<br />
SQL><br />
SQL> set timing off</source><br />
<br />
<br />
<br />
== Declare dbms_utility.get_time as a variable default value==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL> set echo on<br />
SQL><br />
SQL><br />
SQL> create table t ( x int );<br />
Table created.<br />
SQL><br />
SQL> set serveroutput on<br />
SQL><br />
SQL> declare<br />
2 l_start number default dbms_utility.get_time;<br />
3 begin<br />
4 for i in 1 .. 1000<br />
5 loop<br />
6 insert into t values ( 1 );<br />
7 end loop;<br />
8 commit;<br />
9 dbms_output.put_line ( dbms_utility.get_time-l_start || " hsecs" );<br />
10 end;<br />
11 /<br />
19 hsecs<br />
PL/SQL procedure successfully completed.<br />
SQL><br />
SQL><br />
SQL><br />
SQL> drop table t;<br />
Table dropped.<br />
SQL><br />
SQL></source></div>
Admin