PL/SQL Control Statements, Oracle

Language: Layout:

--Oracle 11g Express Edition
--please drop objects you've created at the end of the script 
--or check for their existance before creating
--'\\' is a delimiter

-- Example of PL/SQL If,

DECLARE  
       a number(3) := 500; 
       grade char(1) := 'B';  
        
    BEGIN

dbms_output.put_line(' -------- IF ------------');
       IF( a < 20 ) THEN  
          dbms_output.put_line('a is less than 20 ' );  
       ELSE  
          dbms_output.put_line('a is not less than 20 ' );  
       END IF;  
       dbms_output.put_line('value of a is : ' || a);  
       
       
       dbms_output.put_line(' -------- CASE ------------');
       CASE grade  
       WHEN 'A' THEN dbms_output.put_line('Excellent');  
       WHEN 'B' THEN dbms_output.put_line('Very good');  
       WHEN 'C' THEN dbms_output.put_line('Good');  
       WHEN 'D' THEN dbms_output.put_line('Average');  
       WHEN 'F' THEN dbms_output.put_line('Passed with Grace');  
       ELSE dbms_output.put_line('Failed');  
       END CASE;  
   
       dbms_output.put_line(' -------- OTHER------------');
       
       
       
    END;  
    
    
 --%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%


absolute service time: 1,18 sec