Types of PL/SQL Code Blocks in Oracle

Q

What Are the Types PL/SQL Code Blocks in Oracle?

✍: FYIcenter.com

A

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.

 

Define an Anonymous Block in Oracle

What Is PL/SQL in Oracle

Introduction to Oracle PL/SQL

⇑⇑ Oracle Database Tutorials

2018-10-30, 1709🔥, 0💬