http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2Fdba_job 2026-05-24T12:54:42Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/dba_job&diff=2312&oldid=prev 2010-05-26T13:45:19Z

<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/System_Tables_Views/dba_job&diff=2313&oldid=prev 2010-05-26T10:01:20Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==Query dba_job table==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> SQL&gt;<br /> SQL&gt; column priv_user format a15<br /> SQL&gt; column schema_user format a15<br /> SQL&gt;<br /> SQL&gt; select priv_user,<br /> 2 schema_user,<br /> 3 this_date,<br /> 4 next_date,<br /> 5 decode( failures, null, 0, failures ) failures<br /> 6 from dba_jobs<br /> 7 where rownum &lt; 50<br /> 8 /<br /> PRIV_USER SCHEMA_USER THIS_DATE NEXT_DATE FAILURES<br /> --------------- --------------- -------------------- -------------------- ----------<br /> FLOWS_020100 FLOWS_020100 16-JUN-2008 23:06:50 0<br /> FLOWS_020100 FLOWS_020100 16-JUN-2008 17:39:23 0<br /> sqle sqle 16-JUN-2008 17:30:19 0<br /> sqle sqle 16-JUN-2008 17:30:19 0<br /> 4 rows selected.<br /> SQL&gt;<br /> SQL&gt; --<br /> &lt;/source&gt;</div>

Admin