в 13:45, 26 мая 2010

2010-05-26T13:45:19Z

Admin: 1 версия

2010-05-26T09:59:38Z

1 версия

Новая страница

==Exit when loop==



<source lang="sql">

SQL> declare
2 l_loops number := 0;
3 begin
4 dbms_output.put_line("Before my loop");
5
6 loop
7 exit when l_loops > 4;
8 dbms_output.put_line("Looped " || l_loops || " times");
9 l_loops := l_loops + 1;
10 end loop;
11
12 dbms_output.put_line("After my loop");
13 end;
14 /
Before my loop
Looped 0 times
Looped 1 times
Looped 2 times
Looped 3 times
Looped 4 times
After my loop
PL/SQL procedure successfully completed.
SQL>
</source>

==Use when inside case==



<source lang="sql">

SQL>
SQL> -- switch case
SQL>
SQL>
SQL> declare
2 l_num number := 7;
3 begin
4 case l_num
5 when 1 then dbms_output.put_line("You selected one");
6 when 2 then dbms_output.put_line("You selected two");
7 when 3 then dbms_output.put_line("You selected three");
8 when 4 then dbms_output.put_line("You selected four");
9 when 5 then dbms_output.put_line("You selected five");
10 when 6 then dbms_output.put_line("You selected six");
11 when 7 then dbms_output.put_line("You selected seven");
12 when 8 then dbms_output.put_line("You selected eight");
13 when 9 then dbms_output.put_line("You selected nine");
14 when 0 then dbms_output.put_line("You selected zero");
15 --else dbms_output.put_line("You selected more than one digit...");
16 end case;
17 end;
18 /
You selected seven
PL/SQL procedure successfully completed.
SQL>

</source>

==Use when to catch exceptions==



<source lang="sql">
SQL>
SQL> -- catch Exception
SQL>
SQL> declare
2 l_number number;
3 begin
4 l_number := "MY NUMBER";
5 exception
6 when OTHERS then
7 dbms_output.put_line("Exception caught");
8 raise;
9 end;
10 /
Exception caught
declare
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 8

SQL>

</source>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL/PL SQL/When - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия