What are the types PL/SQL code blocks? Anonymous Block
- It is a block of codes without a name.
- It may contain a declaration part, an execution part, and exception handlers.
Stored Program Unit
- It is a block of codes with a name.
- It is similar to an anonymous block just that it can take parameters and return values.
- It is a block of code that is implicitly fired based some specific event.