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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.