Case with else : Case « PL SQL « Oracle PL / SQL

1. Oracle PL / SQL
2. PL SQL
3. Case

Case with else

 

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>
           
         
  

Related examples in the same category