December 2002
Intermediate to advanced
928 pages
85h 29m
English
You can use collections to improve the performance of SQL operations executed iteratively by using bulk binds. Bulk binds reduce the number of context switches between the PL/SQL engine and the database engine. Bulk binds can also be used to implement dynamic SQL with Oracle9i.
Two PL/SQL language constructs implement bulk binds: FORALL and BULK COLLECT INTO.