Outer Block name and inner block name : Begin End Block « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Begin End Block

Outer Block name and inner block name

  
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>








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.Block with name
12.This script demonstrates the structure of a block
13.Nested block
14.Plain SQL and PL/SQL program