18
Bulk SQL
In Chapter 1, “PL/SQL Concepts,” you learned that the PL/SQL engine sends SQL statements to the SQL engine, which then returns results back to the PL/SQL engine. The communication between the PL/SQL and SQL engines is also known as a context switch. A certain performance overhead is associated with these context switches. However, the PL/SQL language has a number of features that can minimize the performance overhead; they are collectively known as bulk SQL. Generally, if a SQL statement affects four or more rows, bulk SQL may improve performance significantly. Bulk SQL supports batch processing of SQL statements ...
Get Oracle PL/SQL by Example, 6th Edition 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.
