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.
Trigger
- It is a block of code that is implicitly fired based some specific event.
|