File Library

Can Collections Speed Up Your PL/SQL?

Topic: The Database

Owner: Patrick Barel

Date: 2013-05-15

Subtopic: At A Glance

Collections (array-like structures in PL/SQL) are used in two of the most important performance features of PL/SQL: BULK COLLECT for data retrieval and FORALL for data modification.

Collections (array-like structures in PL/SQL) are critical data structures that are used in some of the most important features of PL/SQL. Every PL/SQL developer should have a deep familiarity with collections and the wide range of features that Oracle has implemented for them over the years. This session introduces collections and quickly moves on to detailed explanations of collection methods, how to leverage string indexing in associative arrays, multi-level collections, set-level operations on nested tables and more.

Download File pbarel.cancollectionsspeedup.pdf

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

Not a member? Click through to the topic of interest to browse a list of available presentations.
Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database