Mega Code Archive

 

Categories / Oracle PLSQL / PL SQL

 

Variable scope in a PLSQL

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>