A Dev Gym Workout

Advanced PL/SQL (formerly the Chicago OUG Workout)


Steven Feuerstein originally created this workout for a Chicago Oracle User Group meeting. Instead of talking for hours, he offered this workout for attendees to take, and then review with him. Prizes went to high-ranking players and free ebooks from O'Reilly Media for everyone. Well, no more prizes, our apologies. But you can still test your PL/SQL knowledge with these quizzes.

  • Instructor

    Steven Feuerstein*

  • Estimated Time

    68 Minutes

  • Difficulty

    Intermediate to Advanced

Take Workout

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
Quiz on Autonomous Transactions (17441)Intermediate
Quiz on FORALLIntermediate2
Quiz on Sparse Bind Arrays in FORALLAdvanced10
Quiz on Impact of Table Changes on Result CacheIntermediate6
Quiz on Function Result CacheAdvanced18
Quiz on MULTISET OperatorsAdvanced8
Quiz on Returning Multiple Columns Through Table FunctionAdvanced16
Quiz on Suppress DML Errors with LOG ERRORSAdvanced8
Take Workout
Instructor

*About Steven Feuerstein

Steven Feuerstein is a Senior Advisor at Insum Solutions (https://insum.ca), and is obsessed with the Oracle PL/SQL language, having written ten books on it (all published by O'Reilly Media). You will find an abundance of quizzes from Steven at the Dev Gym. Enjoy!

More from Steven Feuerstein