http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FMiscellaneous_Functions%2FGREATEST
Oracle PL/SQL Tutorial/Miscellaneous Functions/GREATEST - История изменений
2026-04-03T19:03:05Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Miscellaneous_Functions/GREATEST&diff=3510&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://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Miscellaneous_Functions/GREATEST&diff=3511&oldid=prev
Admin: 1 версия
2010-05-26T10:06:34Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== greatest(12*6,148/2,73)==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL><br />
SQL> select greatest(12*6,148/2,73)<br />
2 from dual;<br />
GREATEST(12*6,148/2,73)<br />
-----------------------<br />
74<br />
SQL></source><br />
<br />
<br />
<br />
== GREATEST(12*6,148/2,73) LEAST(12*6,148/2,73)==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL> select greatest(12*6,148/2,73)<br />
2 , least (12*6,148/2,73)<br />
3 from dual;<br />
GREATEST(12*6,148/2,73) LEAST(12*6,148/2,73)<br />
----------------------- --------------------<br />
74 72<br />
SQL><br />
SQL></source><br />
<br />
<br />
<br />
== This script demonstrates the Greatest functions==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL> SET SERVEROUTPUT ON<br />
SQL> DECLARE<br />
2 v_char VARCHAR2(10);<br />
3 v_number NUMBER(10);<br />
4 BEGIN<br />
5<br />
6 v_char := GREATEST("A", "B", "C");<br />
7 v_number := GREATEST(1,2,3);<br />
8<br />
9 DBMS_OUTPUT.PUT_LINE("Greatest Character: "||v_char);<br />
10 DBMS_OUTPUT.PUT_LINE("Greatest Number: "||v_number);<br />
11<br />
12 END;<br />
13 /<br />
Greatest Character: C<br />
Greatest Number: 3<br />
PL/SQL procedure successfully completed.<br />
SQL><br />
SQL></source><br />
<br />
<br />
<br />
== Use the Greatest functions==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL><br />
SQL> SET SERVEROUTPUT ON<br />
SQL> DECLARE<br />
2 v_char VARCHAR2(10);<br />
3 v_number NUMBER(10);<br />
4 BEGIN<br />
5<br />
6 v_char := GREATEST("A", "B", "C");<br />
7 v_number := GREATEST(1,2,3);<br />
8<br />
9 DBMS_OUTPUT.PUT_LINE("Greatest Character: "||v_char);<br />
10 DBMS_OUTPUT.PUT_LINE("Greatest Number: "||v_number);<br />
11<br />
12<br />
13 END;<br />
14 /<br />
Greatest Character: C<br />
Greatest Number: 3<br />
PL/SQL procedure successfully completed.<br />
SQL><br />
SQL></source></div>
Admin