O'Reilly logo

Oracle by Guy Harrison

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required