|
SQL>
SQL> -- case with else
SQL>
SQL> declare
2 l_num number := 8;
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 eight
PL/SQL procedure successfully completed.
SQL>
|