Block with name : Begin End Block « PL SQL « Oracle PL / SQL






Block with name

  
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>

   
  








Related examples in the same category

1.Three sections - declarative, executable, and exception.
2.An example of an anonymous block
3.Block-Based Development
4.The PL/SQL Block
5.Block Nesting
6.The executable section needs at least one line of code to be valid.
7.Five level nested statement
8.no executable code
9.Building Blocks of PL/SQL
10.A Nested Block Example
11.Outer Block name and inner block name
12.This script demonstrates the structure of a block
13.Nested block
14.Plain SQL and PL/SQL program