http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2Fsqltext 2026-05-24T02:22:01Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/sqltext&diff=2374&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/sqltext&diff=2375&oldid=prev 2010-05-26T10:01:26Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==V$SESSION dynamic contains all the currently active users&quot; usernames and the SQL they are executing in the database.==<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; select a.username,<br /> 2 s.sql_text<br /> 3 from v$session a,v$sqltext s<br /> 4 where a.sql_address = s.address<br /> 5 and a.sql_hash_value = s.hash_value<br /> 6 AND A.STATUS=&quot;ACTIVE&quot;<br /> 7 order by a.username,a.sid,s.piece<br /> 8 /<br /> USERNAME<br /> ------------------------------<br /> SQL_TEXT<br /> --------------------------------------------------<br /> sqle<br /> select a.username, s.sql_text from v$session a,v$s<br /> qltext s where<br /> sqle<br /> a.sql_address = s.address and a.sql_hash_value =<br /> s.hash_value A<br /> sqle<br /> ND A.STATUS=&quot;ACTIVE&quot; order by a.username,a.sid,s.p<br /> iece<br /> sqle<br /> DECLARE v_MyNumber NUMBER := 0; BEGIN LOOP<br /> IF v_<br /> sqle<br /> MyNumber = 7 THEN EXIT; END IF;<br /> v_MyNumber<br /> <br /> USERNAME<br /> ------------------------------<br /> SQL_TEXT<br /> --------------------------------------------------<br /> sqle<br /> := v_MyNumber + 2; END LOOP; END;<br /> <br /> 6 rows selected.<br /> SQL&gt;<br /> SQL&gt; --<br /> &lt;/source&gt;</div>

Admin