Another Oracle Dev Gym workout for you...

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.


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 Encapsulate SQL StatementsIntermediate19

*About Steven Feuerstein

Steven Feuerstein leads a team of Developer Advocate at Oracle Corporation, and is obsessed with the Oracle PL/SQL language, having written ten books on it (all published by O'Reilly Media). He's published over 1400 quizzes on PL/SQL at the Oracle Dev Gym.

More from Steven Feuerstein