Case conditions : Case « PL SQL « Oracle PL / SQL

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

Case conditions

 

set echo on;
set verify off;
set define '&';

prompt 'Input degree (numerically in degrees F)?:';
/
accept temp default '100';
/
declare
  too_hot  exception;
  too_cold exception;
begin
  case
    when '&temp' < 90.00 then raise too_cold;
    when '&temp' > 140.00 then raise too_hot;
    else null;
  end case;

  dbms_output.put_line('The temperature is just right');

exception
  when VALUE_ERROR then
    dbms_output.put_line('Please enter a numeric temperature (like 100)');

  when too_hot then
    dbms_output.put_line('The porridge is way too hot...');

  when too_cold then
    dbms_output.put_line('The porridge is way too cold...');
end;
/

           
         
  

Related examples in the same category