PL-SQL Basics

Question 1

What are the advantages of PL-SQL

Answer 1

1) Block structure

2) Better performance: PL/SQL engine processes multiple SQL statements simultaneously as a single block, thereby reducing network traffic.

3) Procedural language capability:
PL/SQL consist of procedural constructs such as conditional statements (if, if else, nested if, else if ladder) and loops (for, while, do while).

4) Error handling:
PL/SQL handles errors or exceptions effectively during the execution of PL/SQL program.