Advantages of PL/SQL

1. Completely Portable.
2. High performance Transaction Processing Language.
3. Support for SQL.
4. Support for Object Oriented Programming.
5. Better Performance.
6. High Productivity.
7. Tight Integration with Oracle.
8. Tight security.

Main Features of PL/SQL:

1. It combines the DATA MANIPULATING power of SQL with the processing power of PROCEDURAL LANGUAGES.
2. Program flow can be controlled using the statements like IF and LOOP.
3. We can declare the variables, Define Procedures and Functions and Trap Run time errors.
4. Can be used to Break complex problems down into easily understandable procedural code.
5. The code can be reused for multiple applications.
6. SQL commands can be directly embedded inside the PL/SQL without learning new API's.
7. The PL/SQL data types correspond with SQL's column types making learning process easier.