SQL>
SQL> set serveroutput on
SQL>
SQL> declare
2 myText varchar2(20);
3 begin
4 myText := 'First Block';
5 dbms_output.put_line(myText);
6 declare
7 l_more_text varchar2(20);
8 begin
9 l_more_text := 'Second Block';
10 dbms_output.put_line(l_more_text);
11 end;
12 end;
13 /
First Block
Second Block
PL/SQL procedure successfully completed.
SQL>
SQL>
|