What is the basic structure of PL/SQL?

› Category: Pl/SQL › What is the basic structure of PL/SQL?
0 Vote Up Vote Down
Editor">Editor Staff asked 2 years ago

What is the basic structure of PL/SQL?

Question Tags:
1 Answers
0 Vote Up Vote Down
Editor">Editor Staff answered 2 years ago

PL/SQL uses BLOCK structure as its basic structure. Each PL/SQL program consists of SQL and PL/SQL statement which form a PL/SQL block.
PL/SQL block contains 3 sections.

  1. The Declaration Section (optional)
  2. The Execution Section (mandatory)
  3. The Exception handling Section (optional)