If PL/SQL code loops through a collection performing the same DML operation for each item in the collection it is possible to reduce context switches by bulk binding the whole collection to the DML statement in one operation.
In Oracle8i a collection must be defined for every column bound to the DML which can make the code rather long winded.
Oracle generously provides a list of things developers can do to tune their PL/SQL code.
One item from that list is probably the single best tool developers have at their disposal to supercharge their code: bulk processing.
Whenever you need to retrieve and modify more than one row of a database table you have a few options: Even though it is possible to use a single SQL statement to modify data in a table, PL/SQL developers rarely take this approach.