Introduction to PL/SQL

PL/SQL stands for Procedural Language/Structured Query Language.

PL/SQL is Extension of SQL Language. It's a language developed by the Oracle corporation and the full name is procedural language/structured query language. PL/SQL is a high performance transaction processing language and also totally portable. It provides a built-in interpreted and operating system independent programming language.

PL/SQL Syntax

1. {DECLARE}
2. declaration ststements;
3. begin
4. executable ststements;
5. {EXCEPTION}
6. exception handling statements;
7. end;

Advantages of PL/SQL

PL/SQL is a Procedural language/Structured query language in which these are following advantages

• Error exceptional handling - It handles the error or exceptions and giving user friendly error message.

• Reduces Network Traffic - PL/SQL nature is Entire block of SQL statement execute to the oracle database engine at once so it's benefit to reduce the Network Traffic.

• Allowance SQL - It is flexible, robust and simply to learn by the support of PL/SQL. it is very easy and conceptual .

• Best performance - It engine procedure multiple sql statement simultaneously.

• Higher productivity - PL/SQL great productivity through enabling using of better tools.

• Completely portability - PL/SQL are portable to all operating system and platform on which Oracle database runs.

• Tight integration with PL/SQL - work properly within oracle database.

• Security - PL/SQL can obtain data abstraction, access control.

• Intermediate Calculation - PL/SQL Enumeration done fast and oracle engines increase the transaction program.

Procedures in PL/SQL

• PL/SQL performs one or more specific task and it is same as in other procedure language. Procedure is also called PL/SQL.

• A procedure language includes a header and a body. The header structure of the name of the procedure and the variables or parameters passed through the procedure.