Answers

Question and Answer:

  Home  Oracle Database

⟩ What Are the Types PL/SQL Code Blocks?

There are 3 types of 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.

 143 views

More Questions for you: