Simple case demo : Case « PL SQL « Oracle PL / SQL

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

Simple case demo

 
-- read user input

set echo off
set define '&'
set verify off
set serveroutput on size 10000

prompt
accept NUM prompt 'Enter a single digit number : '
prompt

declare
  l_num number := #
begin
  case l_num
    when 1 then dbms_output.put_line('You selected one');
    when 2 then dbms_output.put_line('You selected two');
    when 3 then dbms_output.put_line('You selected three');
    when 4 then dbms_output.put_line('You selected four');
    when 5 then dbms_output.put_line('You selected five');
    when 6 then dbms_output.put_line('You selected six');
    when 7 then dbms_output.put_line('You selected seven');
    when 8 then dbms_output.put_line('You selected eight');
    when 9 then dbms_output.put_line('You selected nine');
    when 0 then dbms_output.put_line('You selected zero');
  end case;
end;
/




           
         
  

Related examples in the same category