Another Oracle Dev Gym workout for you...

FORALL - Basic Concepts

Tim Hall 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.


  • Instructor

    Tim Hall*

  • Estimated Time

    45 Minutes

  • Difficulty

    Beginner 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
FORALL StatementNot Provided
Quiz on FORALLBeginner5
Quiz on FORALLIntermediate5
Quiz on FORALLIntermediate2
Quiz on FORALLIntermediate2

*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