Oracle PL/SQL Training in Pune

What is PL/SQL?

PL / SQL is extension of structured query language i.e. SQL used in Oracle. It is not like SQL, PL / SQL allows the programmer to write code in the procedural format. The full form of PL / SQL is “procedural language extensions for SQL.” Combine the power of SQL data manipulation with the power of procedural language to create extremely powerful SQL queries. PL / SQL means telling the SQL compiler what to do and how to do it. Similar to other database languages, it offers programmers greater control using object-oriented loops, conditions, and concepts. Over time, more business logic and application logic has been migrated to Oracle Server, making PL / SQL programming an important part of the overall development process. The PL / SQL developer focuses on the usability, quality, and productivity of the code, the main advantages in developing Oracle applications. PL / SQL stands for Procedure Structure Query Language. The name itself contains a lot of information. In PL / SQL, we save the compiled procedures in executable format to perform a specific task as defined. This is best features of procedural language that can be called remotely anytime, anywhere. Therefore, not necessary to write code repeatedly.

The architecture of PL/SQL

The PL/SQL architecture mainly consists of the following three components:

1. PL/SQL block
2. PL/SQL Engine
3. Database Server

PL/SQL block:

• This is the component with the actual PL / SQL code.

• It consists of various sections for the logical division of the code (declarative section for reporting purposes, execution section for processing instructions, a section for handling exceptions for handling errors)

• It also contains the SQL statements used to interact with the database server.

• All PL / SQL units are treated as PL / SQL blocks and are the initial phase of the architecture, which acts as the main input.

Here are the different types of PL / SQL units.

• • Anonymous Block
  • Function
  • Library
  • Procedure
  • Package Body
  • Package Specification
  • Trigger
  • Type
  • Type Body

PL/SQL Engine

• The PL / SQL engine is the component where the actual processing of the code takes place.

• The PL / SQL engine separates the PL / SQL units and the SQL part at the input (as shown in the following figure).

• Separate PL / SQL units are managed by the PL / SQL engine itself.

• The SQL part is sent to the database server where actual interaction with the database takes place.

• Can be installed on the database server and the application serve

• PL/SQL engine is the component where actual processing of codes takes place.
• PL/SQL engine separates PL/SQL units, SQL part in input 
• The separated PL/SQL units will handled by the PL/SQL engine itself.
• The SQL part will be sent to the database server where the actual interaction with the database takes place.
• It can be installed in both the database server and in the application server.

Database Server:

• It is the most important component of the PI / SQL unit that stores data.

• The PL / SQL engine uses SQL from PL / SQL units to interact with the database server.

• It consists of the SQL executor, which analyzes and executes the inserted SQL statements.

Advantage of Using PL/SQL

1. Better performance because SQL runs in the block instead of a single statement 
2. High Productivity
3. Tight integration with SQL
4. Full Portability
5. Tight Security
6. Support Object-Oriented Programming concepts.