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

<p>1 версия</p> <p><b>Новая страница</b></p><div>==Query SQL 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; select * from dual;<br /> D<br /> -<br /> X<br /> SQL&gt; select * from DUAL;<br /> D<br /> -<br /> X<br /> SQL&gt;<br /> SQL&gt; select sql_text, hash_value from v$sql where upper(sql_text) = &quot;SELECT * FROM DUAL&quot;;<br /> SQL_TEXT<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> HASH_VALUE<br /> ----------<br /> select * from DUAL<br /> 3649189949<br /> select * from dual<br /> 942515969<br /> SQL_TEXT<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> HASH_VALUE<br /> ----------<br /> select * from dual<br /> 942515969<br /> <br /> 3 rows selected.<br /> SQL&gt;<br /> SQL&gt; alter session set OPTIMIZER_MODE = first_rows;<br /> Session altered.<br /> SQL&gt;<br /> SQL&gt; select * from dual;<br /> D<br /> -<br /> X<br /> &lt;/source&gt;<br /> <br /> <br /> <br /> <br /> ==select sql_text, hash_value, parsing_user_id, optimizer_mode from v$sql==<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 * from dual;<br /> D<br /> -<br /> X<br /> SQL&gt;<br /> SQL&gt; select sql_text, hash_value, parsing_user_id<br /> 2 from v$sql<br /> 3 where upper(sql_text) = &quot;SELECT * FROM DUAL&quot;;<br /> SQL_TEXT<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> HASH_VALUE PARSING_USER_ID<br /> ---------- ---------------<br /> select * from DUAL<br /> 3649189949 0<br /> select * from dual<br /> 942515969 0<br /> SQL_TEXT<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> HASH_VALUE PARSING_USER_ID<br /> ---------- ---------------<br /> select * from dual<br /> 942515969 0<br /> <br /> 3 rows selected.<br /> SQL&gt;<br /> SQL&gt; select sql_text, hash_value, parsing_user_id, optimizer_mode<br /> 2 from v$sql<br /> 3 where upper(sql_text) = &quot;SELECT * FROM DUAL&quot;;<br /> SQL_TEXT<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> HASH_VALUE PARSING_USER_ID OPTIMIZER_<br /> ---------- --------------- ----------<br /> select * from DUAL<br /> 3649189949 0 RULE<br /> select * from dual<br /> 942515969 0 RULE<br /> SQL_TEXT<br /> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br /> HASH_VALUE PARSING_USER_ID OPTIMIZER_<br /> ---------- --------------- ----------<br /> select * from dual<br /> 942515969 0 FIRST_ROWS<br /> <br /> 3 rows selected.<br /> SQL&gt;<br /> &lt;/source&gt;</div>

Admin