SQL>
SQL> <<main_loop>>
2 DECLARE
3 lv_var_num_1 PLS_INTEGER := 5;
4 BEGIN
5
6 DBMS_OUTPUT.PUT_LINE('Step 1: ' || lv_var_num_1);
7 <<inner_loop>>
8 DECLARE
9 lv_var_num_1 PLS_INTEGER := 3;
10 lv_var_num_2 PLS_INTEGER := 9;
11 BEGIN
12 DBMS_OUTPUT.PUT_LINE('Step 2: ' || lv_var_num_1);
13 DBMS_OUTPUT.PUT_LINE('Step 3: ' || main_loop.lv_var_num_1);
14 DBMS_OUTPUT.PUT_LINE('Step 4: ' || lv_var_num_2);
15
16 lv_var_num_1 := 6;
17 DBMS_OUTPUT.PUT_LINE('Step 5: ' || lv_var_num_1);
18 END;
19 DBMS_OUTPUT.PUT_LINE('Step 7: ' || lv_var_num_1);
20 END;
21 /
Step 1: 5
Step 2: 3
Step 3: 5
Step 4: 9
Step 5: 6
Step 7: 5
PL/SQL procedure successfully completed.
SQL>
SQL>
|