An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management.

​

 1  PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java. 
2  PL/SQL is a combination of SQL along with the procedural features of programming languages. 
3  It was developed by Oracle Corporation in the early 90's to enhance the capabilities of SQL. 

 

   Features of PL/SQL PL/SQL has the following features: PL/SQL is tightly integrated with SQL. 
4  PL/SQL provides support for Object-Oriented Programming. 
5  PL/SQL provides support for Developing Web Applications and Server Pages. 
6  It offers numerous data types. 
7  This reduces network traffic and provides high performance for the applications. 
8  PL/SQL provides access to predefined SQL packages. 
9  It supports developing web applications and server pages. 
10   Static SQL supports DML operations and transaction control from PL/SQL block. 
11 PL/SQL saves time on design and debugging by strong features, such as exception handling, encapsulation, data hiding, and object-oriented data types. 
12  Advantages of PL/SQL PL/SQL has the following advantages: SQL is the standard database language and PL/SQL is strongly integrated with SQL. 
13  PL/SQL allows sending an entire block of statements to the database at one time. 
14 It offers extensive error checking. 
15 It supports structured programming through functions and procedures. 
16  PL/SQL gives high productivity to programmers as it can query, transform, and update data in a database. 
17  PL/SQL supports both static and dynamic SQL. 
18  Applications written in PL/SQL are fully portable. 
19  It offers a variety of programming structures. 
20  It supports object-oriented programming. 
21  PL/SQL provides high security level. 
22  Dynamic SQL is SQL allows embedding DDL statements in PL/SQL blocks. 
 

​