A Dev Gym Workout

Advanced PL/SQL Gems


This workout offers as exercises all the quizzes that were originally played in PL/SQL Championship for Q2 2012 - but don't worry! They're still more than relevant to your work today. Warning: they're advanced and they cover a variety of topics in the PL/SQL language. How will you stack up against the championship players? :-)
  • Instructor

    Steven Feuerstein*

  • Estimated Time

    102 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
Quiz on ORA-00942: Table or view does not existAdvanced21
Quiz on Emulating Unique Indexes in an Associative ArrayAdvanced21
Quiz on Impact of Changing Parameter List with Fine-Grained DependencyAdvanced20
Quiz on DBMS_UTILITY.COMMA_TO_TABLEAdvanced21
Quiz on Encapsulate SQL StatementsIntermediate19
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