PL/SQL is a transaction processing procedural language that has the following advantages:
a. Integration with database — PL/SQL supports SQL statements, thus enabling integration between procedural language capabilities and the database technology.
b. 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.
c. Higher productivity — PL/SQL helps the package reusable code within the well-defined modular blocks; and therefore, increases the productivity.
d. Portability — Programs packages and libraries written in PL/SQL can be reused in different environments.
a. Integration with database — PL/SQL supports SQL statements, thus enabling integration between procedural language capabilities and the database technology.
b. 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.
c. Higher productivity — PL/SQL helps the package reusable code within the well-defined modular blocks; and therefore, increases the productivity.
d. Portability — Programs packages and libraries written in PL/SQL can be reused in different environments.
No comments:
Post a Comment