|
SQL>
SQL>
SQL> <<BLOCK1>>
2 DECLARE
3 lv_var_num1 NUMBER := 10;
4 BEGIN
5 <<BLOCK2>>
6 DECLARE
7 lv_var_num1 NUMBER := 20;
8 BEGIN
9 DBMS_OUTPUT.PUT_LINE('Value for lv_var_num1: ' ||
10 lv_var_num1);
11 DBMS_OUTPUT.PUT_LINE('Value for BLOCK1.lv_var_num1: ' ||
12 block1.lv_var_num1);
13 DBMS_OUTPUT.PUT_LINE('Value for BLOCK2.lv_var_num1: ' ||
14 block2.lv_var_num1);
15 END BLOCK2;
16 END BLOCK1;
17 /
Value for lv_var_num1: 20
Value for BLOCK1.lv_var_num1: 10
Value for BLOCK2.lv_var_num1: 20
PL/SQL procedure successfully completed.
SQL>
|