Another Oracle Dev Gym workout for you...

Gold Medal PL/SQL

This workout offers as exercises all the quizzes that were originally played in PL/SQL Championship for Q4 2010 - 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

    183 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 REJECT LIMIT clause of the LOG ERRORS statementAdvanced12
Quiz on Session-Specific Dependencies in Result-Cached FunctionsAdvanced21
Quiz on RETURNING Information from DELETEsIntermediate21
Quiz on Overriding MethodsIntermediate18
Quiz on The VALUES OF ClauseAdvanced18
Quiz on Referencing Undefined Inquiry DirectivesIntermediate12
Quiz on Working with Hierarchy of IdentifiersAdvanced19
Quiz on Commit and Rollback Inside DML TriggerIntermediate21
Quiz on Profiling and Tracing PL/SQL ProgramsIntermediate20
Quiz on Specifying Index Value in Nested CollectionIntermediate21

*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