Steven covers the two most important performance features of PL/SQL: BULK COLLECT and FORALL. BULK COLLECT: SELECT statements that retrieve multiple rows with a single fetch, improving the speed of data retrieval FORALL: INSERTs, UPDATEs, and DELETEs that use collections to change multiple rows of data very quickly

Steven Feuerstein explores the benefits of applying FORALL and BULK COLLECT to address performance issues in PL/SQL program units.

An overview from Tim Hall of the bulk processing features of PL/SQL, embodied in the BULK COLLECT and FORALL syntax.

Connor McDonald applies the row-by-row "anti-pattern" to eating a bowl of cereal.

This lesson demonstrates the steps needed to convert from "legacy" code that still relies on row-by-row fetching of data and repeated DMl statement execution, to a phased approach based on FORALL and BULK COLLECT.