Advantages of PL/SQL:

SQL Support

SQL has become the standard database language since it is flexible, easy and powerful to learn. Because it is a non-procedural language and a user want not know how the statements are processed but just needs to denote the requirement.

PL/SQL  permits  the  usage  of  all  types  of  SQL  data  manipulation,  cursor  control  and transaction control statements as well as all the SQL operators, functions and pseudocolumns.

Better performance

Without PL/SQL Oracle would process SQL statements one at a time. Every SQL statement results in another Oracle call to Oracle and higher performance overhead. Because PL/SQL can holds  SQL  statements the entire  SQL  statements  can  be  placed  inside  PL/SQL  thus reducing the time taken for communication among the server and the application. This decrease network traffic and results in better performance.

Support for Object Oriented Programming

An Oracle implements the concept of OOPs object oriented programming. This permits the creation of software components which are modular, reusable and maintainable. By using encapsulation operations with the data object kinds lets users to move data-maintenance codes out of SQL scripts and PL/SQL blocks into methods.

Portability

Applications written in PL/SQL give portability to the operating system and platform on that they run. Wherever Oracle can run these applications also run.

Higher Productivity

PL/SQL adds functionality to Oracle's non-procedural tools such as Reports and Forms. These tools can help to build applications using familiar procedural constructs. A PL/SQL does not differ in environments. It works the similar way as it works for other built-in tools. Additionally any scripts written using one tool can be used through another tool.

Integration with Oracle

PL/SQL and Oracle are based on SQL statements. It will support all the SQL Datatypes. These types of Datatypes integrate PL/SQL with the Oracle Data dictionary.