PL/SQL variables and constant, Oracle

PL/SQL variables and constant

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

-- ***************************************************************
-- global variable, local variable, and constant declaration
 
 DECLARE
 -- global variable
 num1 number := 95;
 num2 number := 85;
 
 pi constant number := 3.141592654;   -- constant declaration  
 -- other declarations  
 radio number(5,2);   
 circunferencia number(7,2);   
 
 BEGIN
 -- Run it    save it   live cooperation  put on a wall
 dbms_output.put_line('outer variable num1: ' || num1);
 dbms_output.put_line('outer variable num2: ' || num2);
 
 radio := 9.5;
 circunferencia := 2.0 * pi * radio;
 
 dbms_output.put_line('outer radio: ' || radio);
 dbms_output.put_line('outer circunferencia: ' || circunferencia);
 
     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