PL SQL

PL SQL stands for Procedural Language extensions to SQL is a Structured Query Language (SQL) that is used in Oracle. It includes procedural language elements such as conditions & loops where it also allows declaration of constants and variables, procedures and functions and triggers. It can handle exceptions (runtime errors).Hence allows the programmer to write code in a procedural format.

It resolves SQL Queries by combining the data manipulation power of SQL with the processing power of procedural language.It means  instructing the compiler ‘what to do’ through SQL and ‘how to do’ through its procedural way.

A stored procedure is referred as, where PL/SQL program is stored in a database in compiled form and is  implicitly started when an INSERT, UPDATE or DELETE statement is issued against an associated table is called a trigger.

Benefits of Using PL/SQL:

PL/SQL Helps in Better performance, as SQL is executed in bulk rather than a single statement and maintains Tight Security with Full Portability and performs High Productivity to Support Object Oriented Programming concepts.