In this chapter, you will learn about
• The FORALL statement
• The BULK COLLECT clause
In Chapter 1, “PL/SQL Concepts,” you learned that the PL/SQL engine sends SQL statements to the SQL engine, which returns results to the PL/SQL engine. The communication between the PL/SQL and SQL engines is called a context switch. A certain amount of performance overhead is associated with these context switches. However, the PL/SQL language has a number of features that can minimize the performance overhead 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 and their results. It consists of ...