Another Oracle Dev Gym workout for you...

BULK COLLECT


Tim Hall of oracle-base.com 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.

Information

  • Instructor

    Tim Hall*

  • Estimated Time

    84 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.

Exercises

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 OptionsIntermediate5
Quiz on Terminating loops that utilize BULK COLLECT with LIMITIntermediate7
Quiz on BULK COLLECT behavior when no rows are foundIntermediate5
Quiz on Using BULK COLLECT with Dynamic SQLIntermediate6
Instructor

*About Tim Hall

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

More from Tim Hall