Begin End Block « PL SQL « Oracle PL / SQL

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 executable code
9.Building Blocks of PL/SQL

10.A Nested Block Example
11.Block with name
12.Outer Block name and inner block name
13.This script demonstrates the structure of a block
14.Nested block
15.Plain SQL and PL/SQL program