Use this blog post to quickly get to some of the best resources on bulk processing - from articles to quizzes to workouts to tutorials.
LiveSQL TutorialI offer a 19-module tutorial on all things bulk processing here. I complement the explanations with lots of code to run and explore, along with:
- Fill in the Blanks: partially-written code that you need to finish up, that reinforces the content of that module
- Exercises: You do all the coding to solve the stated requirement (be on the lookout for copy/paste opportunities from the module to speed things up).
Oracle-BASE ContentYou can always depend on Tim Hall to offer comprehensive coverage of SQL and PL/SQL features, with straightforward, easy-to-run code snippets to drive the points home. You'll find his coverage of bulk processing here.
Oracle DocumentationThe Bulk SQL and Bulk Binding section of the PL/SQL Users Guide is packed full of syntax, links to related content, and tips on how to best take advantage of FORALL and BULK COLLECT.
Oracle Dev Gym WorkoutsThe Oracle Dev Gym offers multiple choices quizzes, workouts and classes on a wide variety of Oracle Database topics. Find below a set of four workouts (three featuring content by Tim Hall) on FORALL and BULK COLLECT.
BULK COLLECT by Tim Hall
Tim explores the BULK COLLECT feature of PL/SQL, which allows you to retrieve multiple rows with a single fetch. Note that Tim's article also covers FORALL, which is for multi-row, non-query DML (inserts, updates, deletes) and will be explored in a separate workout. After you read his article and check out the documentation, it's time to take four quizzes written by your truly to test your knowledge of this feature.
FORALL - Basic Concepts by Tim Hall
Tim offers a comprehensive review of bulk processing in PL/SQL; this workout focuses in on FORALL, covering the basic concepts behind this powerful performance enhancer. We complement Tim's article with a link to documentation and FORALL quizzes from the Dev Gym library.
FORALL and SAVE EXCEPTIONS by Tim Hall
Tim provides a comprehensive review of bulk processing in PL/SQL in this workout's leading exercise. Drill down to the SAVE EXCEPTIONS section of Tim's article to explore how to handle exceptions that may be raised when FORALL executes. Check out the documentation for more details. Then finish up with quizzes from your truly on SAVE EXCEPTIONS. Go beyond FORALL basics with this workout!
An Hour (more or less) of Bulk Processing Quizzes
Ten quizzes on FORALL and BULK COLLECT, ranging in difficulty from beginner to intermediate.
Other Blog Posts and ArticlesMy article in Oracle Magazine: Bulk Processing with BULK COLLECT and FORALL
Blog post: A checklist for Bulk Processing Conversions in PL/SQL