- Blocks broken into three parts
- Declaration
- Variables declared and initialised
- Execution
- Variables manipulated/actioned
- Exception
- Error raised and handled during exec
DECLARE
---declarations
BEGIN
---statements
EXCEPTION
---handlers
END ;
In Focus
4.1.08. PL/SQL