PL/SQL变量应用实例讲解

 -- Created on 2018/3/21 by E.WANG

    
 declare 
    
   /*
    
   全局变量
    
   初始化变量
    
   */
    
   userName char(10) default 'ewang';
    
   age int:=33;
    
   address varchar2(50);
    
 begin
    
   -- Test statements here
    
   address:='shang hai pudong';
    
   dbms_output.put_line('-----------------alter before--------------------' );
    
   dbms_output.put_line('user name:' || userName);
    
   dbms_output.put_line('user age:' || age);
    
   dbms_output.put_line('user address:' || address);
    
   
    
   
    
   declare