PL/SQL is a procedural language designed specifically to embrace SQL statements within its syntax.
PL/SQL program units are compiled by the Oracle Database server and stored inside the database.
And at run-time, both PL/SQL and SQL run within the same server process, bringing optimal efficiency.
PL/SQL automatically inherits the robustness, security, and portability of the Oracle Database
Features & Advantages of PL/SQL
Better performance, as SQL is executed in bulk rather than a single statement.
- High Productivity
- Tight integration with SQL
- Full Portability
- Tight Security
- Supports Object Oriented Programming concepts
- Scalability and Manageability
- Supports Web Application Development