PL/SQL declaracionVariables, Oracle

PL/SQL declaracionVariables

--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

-- ***************************************************************
/*
    DECLARE  
       a integer := 30;  
       b integer := 40;  
       c integer;  
       f real;  
    BEGIN  
       c := a + b;  
       dbms_output.put_line('Value of c: ' || c);  
       f := 100.0/3.0;  
       dbms_output.put_line('Value of f: ' || f);  
    END;  
   */
   
   
-- ***************************************************************
 
 DECLARE
 -- global variable
 num1 number := 95;
 num2 number := 85;
 
 BEGIN
 dbms_output.put_line('outer variable num1: ' || num1);
 dbms_output.put_line('outer variable num2: ' || num2);
 
     DECLARE
     -- local variable
     num1 number:= 195;
     num22 number:= 185;
     
     BEGIN
     dbms_output.put_line('inner variable num1: ' || num1);
     dbms_output.put_line('inner variable num1: ' || num2);
     dbms_output.put_line('inner variable num1: ' || num22);
     END;
 END;
 
 
 -- ***************************************************************


run \| edit \| history \| help	0

λ

                                      .NET NoSQL database for rapid development