File Library

Turbocharge Your PL/SQL Code with Bulk Processing

Topic: Webinars

Owner: Steven Feuerstein

Date: 2014-11-13

Subtopic: Development

Steven Feuerstein, Oracle Corporation

This session focuses on how to turbocharge the performance of multi-row SQL statements executed from within a PL/SQL using FORALL and BULK COLLECT. These features have been around since Oracle 8i, but many developers still don't use them or only scratch the surface of what is possible.
The bulk processing webinar will focus on why these features were needed and how they work. Steven will start with simple examples and syntax and drill down into all nuances, including the LIMIT clause for BULK COLLECT and the SAVE EXCEPTIONS, INDICES OF, and VALUES OF clauses for FORALL.
After attending this webinar, you will be able to both create new programs built around these features and also redesign existing programs safely to improve performance.

Download File Turbocharge Your PL_SQL Code with Bulk Processing SFeuerstein.wmv

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