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