http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FAnalytical_Functions%2FMODEL 2026-05-24T15:10:27Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Analytical_Functions/MODEL&diff=3408&oldid=prev 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/Analytical_Functions/MODEL&diff=3409&oldid=prev 2010-05-26T10:06:14Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>== The MODEL statement does calculations on a column in a row based on other rows in a result set.==<br /> <br /> &lt;p&gt;The MODEL or SPREADSHEET clause is very much like treating the result set of a query as a multidimensional array.&lt;/p&gt;<br /> &lt;p&gt;The keywords MODEL and SPREADSHEET are synonymous.&lt;/p&gt;<br /> &lt;p&gt;The MODEL or SPREADSHEET clause allows us to compute a row in the result set that can retrieve data on some other row(s) without explicitly defining a virtual table.&lt;/p&gt;<br /> &lt;p&gt;The overall syntax for the MODEL or SPREADSHEET SQL statement&lt;/p&gt;<br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> &lt;prior clauses of SELECT statement&gt;<br /> MODEL [main]<br /> [reference models]<br /> [PARTITION BY (&lt;cols&gt;)]<br /> DIMENSION BY (&lt;cols&gt;)<br /> MEASURES (&lt;cols&gt;)<br /> [IGNORE NAV] | [KEEP NAV]<br /> [RULES<br /> [UPSERT | UPDATE]<br /> [AUTOMATIC ORDER | SEQUENTIAL ORDER]<br /> [ITERATE (n) [UNTIL &lt;condition&gt;] ]<br /> ( &lt;cell_assignment&gt; = &lt;expression&gt; ... )&lt;/source&gt;</div>

Admin