What Are the Types PL/SQL Code Blocks?
• Anonymous Block – A block of codes with no name. It may contain a declaration part, an execution part, and exception handlers. • Stored Program Unit – A block of codes with a name. It is similar to an anonymous block. But it can take parameters and return values. • Trigger – A block of code that can be defined to fire based an specific event.