A Dev Gym Workout

Challenging PL/SQL for Dedicated Developers


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

    192 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 Restrictions on Cursor VariablesAdvanced16
Quiz on Object Type HierarchiesAdvanced18
Quiz on Compiler Canonicalization of SQL StatementsAdvanced18
Quiz on Errors that are not handled by SAVE EXCEPTIONSAdvanced20
Quiz on INLINE PragmaAdvanced19
Quiz on Restrictions on use of FORALLIntermediate19
Quiz on Raising ExceptionsIntermediate19
Quiz on Forcing Compilation Errors with Compile-Time WarningsAdvanced22
Quiz on The MEMBER OF ConditionAdvanced21
Quiz on Column Size and Constraint on ParameterIntermediate19
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