Chapter 12. Using and Tuning PL/SQL

PL/SQL is a procedural programming language tightly integrated with the Oracle RDBMS, which allows programs to be stored and executed in the database as stored procedures, functions, and triggers. Anonymous PL/SQL blocks—which are not stored in the database—might also be directly submitted by an application.

PL/SQL offers a rich and productive environment in which to implement database-centric application logic. Also, PL/SQL can often enhance the performance of problematic queries and can offer significant performance improvements for complex DML.

PL/SQL programs are highly tunable. In addition to the code optimization strategies applicable to all procedural languages, PL/SQL has a number of features specifically ...

Get Oracle now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.