PLSQL

Advantages of PL/SQL

Advantages of PL/SQL

  1. It is a standard database language and PL/SQL is strongly integrated with SQL. PL/SQL supports both static and also dynamic SQL. Static SQL is said to support DML operations and also the transaction control from PL/SQL block. In dynamic SQL, SQL allows embedding the DDL statements in the PL/SQL blocks. 
  2. Also, It then allows sending an entire block of statements to the database at one time. It reduces network traffic and also provides high performance for the applications. 
  3. It gives high productivity to programmers as it can query, transform and also update the data in the database. 
  4. This is said to save time on the design and also the debugging by strong features, like the exception handling, encapsulation, data hiding and also object-oriented data types.
  5. Applications that are written in PL/SQL languages are portable.
  6. this provides high security level.
  7. It also provides access to the predefined SQL packages.
  8. It also supports for Object-oriented programming. 
  9. It provides support for developing web applications and server pages.