|
Answer» PL/SQL is a transaction processing procedural language that has the following advantages:
- Integration with database —PL/SQL SUPPORTS SQL statements, thus enabling integration between procedural language capabilities and the database technology.
- Better performance —SQL statements are grouped within a PL/SQL block and sent TOGETHER to database for parsing; therefore, it reduces the network traffic and increases the performance.
- Higher productivity —-PL/SQL HELPS the package reusable code within the well-defined modular blocks; and therefore, increases the productivity.
- Portability —Programs PACKAGES and libraries written in PL/SQL can be reused in DIFFERENT environments.
PL/SQL is a transaction processing procedural language that has the following advantages:
|