PL/SQL is Oracle's procedural language extension to SQL. PL/SQL enables you to mix SQL statements with procedural constructs.
With PL/SQL, you can define and execute PL/SQL program units such as Procedures, Functions and Packages.
PL/SQL program units gernerally categorized as Anonymus blocks and Stored Procedures.
PL/SQL is completely portable, hifh-performance transaction processing language that offers the following advantages -
- Support to SQL
- Higher productivity
- Better performance
- Portability
- Integration with Oracle