![]() ![]() PL/SQL provides support for Object-Oriented Programming. ![]() PL/SQL provides access to predefined SQL packages. PL/SQL saves time on design and debugging by strong features, such as exception handling, encapsulation, data hiding, and object-oriented data types.Īpplications written in PL/SQL are fully portable. ![]() PL/SQL gives high productivity to programmers as it can query, transform, and update data in a database. This reduces network traffic and provides high performance for the applications. PL/SQL allows sending an entire block of statements to the database at one time. In Dynamic SQL, SQL allows embedding DDL statements in PL/SQL blocks. Static SQL supports DML operations and transaction control from PL/SQL block. PL/SQL supports both static and dynamic SQL. SQL is the standard database language and PL/SQL is strongly integrated with SQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |