Question

Explain what are The Advantages Of Pl/sql?

Answer 1

PL/SQL is a transaction processing procedural language that has the following advantages:

1. Integration with database —PL/SQL supports SQL statements, thus enabling integration between procedural language capabilities and the database technology.
2. 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.
3. Higher productivity —-PL/SQL helps the package reusable code within the well-defined modular blocks; and therefore, increases the productivity.
4. Portability —Programs packages and libraries written in PL/SQL can be reused in different environments.