Bulk Processing with BULK COLLECT and FORALL
Source: https://blogs.oracle.com/oraclemagazine/bulk-processing-with-bulk-collect-and-forall In the previous article in this series, I introduced readers to PL/SQL collections. These data structures come in very handy when implementing algorithms that manipulate lists of program data, but they are also key elements in some of the powerful performance optimization features in PL/SQL. In this article, I will cover the two most important of these features: BULK COLLECT and FORALL. BULK COLLECT: SELECT statements that retrieve multiple rows with a single fetch, improving the speed of data…