1.

What Are The Advantages Of Pl/sql?

Answer»

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.

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



Discussion

No Comment Found