http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FFunction_Procedure_Packages%2FNested_Functions
Oracle PL/SQL Tutorial/Function Procedure Packages/Nested Functions - История изменений
2026-05-24T08:46:23Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Function_Procedure_Packages/Nested_Functions&diff=4418&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://www.sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Function_Procedure_Packages/Nested_Functions&diff=4419&oldid=prev
Admin: 1 версия
2010-05-26T10:11:54Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== Define inner function to calculate age==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL> set serveroutput on<br />
SQL> set echo on<br />
SQL> declare<br />
2 age binary_integer;<br />
3<br />
4 birth_date date;<br />
5 current_date date;<br />
6<br />
7 function age_as_of (birth_date in date, as_of_date in date) return positive is<br />
8 as_of_year natural; --a year of 00 is valid.<br />
9 as_of_month positive;<br />
10 as_of_day positive;<br />
11<br />
12 birth_year natural; --a year of 00 is valid.<br />
13 birth_month positive;<br />
14 birth_day positive;<br />
15<br />
16 age positive;<br />
17 begin<br />
18 as_of_year := to_number(to_char(as_of_date,"yyyy"));<br />
19 as_of_month := to_number(to_char(as_of_date,"mm"));<br />
20 as_of_day := to_number(to_char(as_of_date,"dd"));<br />
21<br />
22 birth_year := to_number(to_char(birth_date,"yyyy"));<br />
23 birth_month := to_number(to_char(birth_date,"mm"));<br />
24 birth_day := to_number(to_char(birth_date,"dd"));<br />
25<br />
26 if as_of_month > birth_month then<br />
27 age := as_of_year - birth_year;<br />
28 elsif (as_of_month = birth_month) and (as_of_day >= birth_day) then<br />
29 age := as_of_year - birth_year;<br />
30 else<br />
31 age := as_of_year - birth_year - 1;<br />
32 end if;<br />
33<br />
34 return age;<br />
35 end;<br />
36 begin<br />
37<br />
38 current_date := to_date("11-13-1997","mm-dd-yyyy");<br />
39 birth_date := to_date("11-15-1961","mm-dd-yyyy");<br />
40<br />
41<br />
42 age := age_as_of (birth_date, current_date);<br />
43 dbms_output.put_line(age);<br />
44<br />
45 end;<br />
46 /<br />
35<br />
PL/SQL procedure successfully completed.<br />
SQL><br />
SQL></source><br />
<br />
<br />
<br />
== Nested function in anonymous block==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL> set echo on<br />
SQL> set serveroutput on<br />
SQL><br />
SQL> declare<br />
2<br />
3 function myFunction (myValue in number,myFactor in number) return number is<br />
4<br />
5 myFactor_to_use number;<br />
6 minimum_wage number := 5;<br />
7 begin<br />
8 if (myFactor is null) or (myFactor < minimum_wage) then<br />
9 myFactor_to_use := minimum_wage;<br />
10 else<br />
11 myFactor_to_use := myFactor;<br />
12 end if;<br />
13<br />
14 return myValue * myFactor_to_use;<br />
15 end;<br />
16 begin<br />
17 dbms_output.put_line(myFunction(40,10));<br />
18 dbms_output.put_line(myFunction(40,2));<br />
19 dbms_output.put_line(myFunction(40,null));<br />
20 end;<br />
21 /<br />
400<br />
200<br />
200<br />
PL/SQL procedure successfully completed.<br />
SQL><br />
SQL></source></div>
Admin