Variable scope in a PL/SQL
SQL> SQL> SQL> declare -- begin first block 2 l_text varchar2(20); 3 begin 4 l_text := 'First Block'; 5 dbms_output.put_line(l_text); 6 declare -- begin second block 7 l_more_text varchar2(20); 8 begin 9 l_more_text := 'Second Block'; 10 dbms_output.put_line(l_more_text); 11 end; -- end second block 12 end; -- end first block 13 / First Block Second Block PL/SQL procedure successfully completed. SQL> SQL> SQL>