Another Oracle Dev Gym workout for you...

Advance Your PL/SQL Skills


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

Information

  • Instructor

    Steven Feuerstein*

  • Estimated Time

    214 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 Column type restrictions with DBMS_ERRLOGIntermediate21
Quiz on The INDICES OF ClauseAdvanced21
Quiz on AUTHID (Invoker and Definer Rights)Intermediate21
Quiz on Repeating Placeholder Names in Dynamic SQL StatementsAdvanced21
Quiz on Selection DirectivesAdvanced21
Quiz on The Basic LOOP StatementIntermediate21
Quiz on MULTISET OperatorsAdvanced22
Quiz on Declaring REF CURSOR Types and Cursor VariablesIntermediate20
Quiz on Terminating loops that utilize BULK COLLECT with LIMITIntermediate23
Quiz on User-Defined ExceptionsAdvanced24
Instructor

*About Steven Feuerstein

Steven Feuerstein is the Oracle Developer Advocate for PL/SQL at Oracle Corporation, and is considered a leading expert on the Oracle PL/SQL language, having written ten books on PL/SQL (all published by O'Reilly Media). He's published over 1400 quizzes on PL/SQL at the Oracle Dev Gym.

More from Steven Feuerstein