Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Statements

 

A nested block which declares and prints a variable of the same name

SQL> SQL> set echo on SQL> set serveroutput on SQL> declare   2    state_name  varchar2(30);   3   4  begin   5    state_name := 'A';   6   7    declare   8      state_name  varchar2(30);   9    begin  10      state_name := 'B';  11      dbms_output.put_line(state_name);  12    end;  13  14    --Now print the state_name variable's value in the outer block.  15    dbms_output.put_line (state_name);  16  end;  17  / B A PL/SQL procedure successfully completed. SQL>