Another Oracle Dev Gym workout for you...


Tim Hall of fame 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 Steven Feuerstein to test your knowledge of this feature.


  • Instructor

    Tim Hall*

  • Estimated Time

    78 Minutes

  • Difficulty

    Intermediate to Advanced

Oracle Account Text

You need an Oracle Account to take a workout. Click here to sign up.
Already a member of the Oracle Dev Gym? Click here to get back to work.


Exercise Difficulty Time
Bulk Binds (BULK COLLECT & FORALL) and Record Processing in OracleAdvanced30
BULK COLLECT Clause (documentation)Not Provided20
Quiz on Associative Arrays Used with BULK COLLECTIntermediate6
Quiz on Bulk-Fetching from a Cursor Into One Collection of RecordsIntermediate5
Quiz on BULK COLLECT and Cursor OptionsIntermediate2
Quiz on Terminating loops that utilize BULK COLLECT with LIMITIntermediate7
Quiz on BULK COLLECT behavior when no rows are foundIntermediate2
Quiz on Using BULK COLLECT with Dynamic SQLIntermediate6

*About Tim Hall

Tim Hall is an Oracle DBA/Developer and well known Oracle blogger at If that isn't enough, he's written two books and over 900 articles, is an Oracle ACE Director, Oracle Groundbreaker Ambassador, OakTable member, and has presented at numerous user groups and conferences worldwide.

More from Tim Hall