Another Oracle Dev Gym workout for you...

Advanced PL/SQL (formerly the Chicago OUG Workout)


Steven Feuerstein originally created this workout for a Chicago Oracle User Group meeting. Instead of talking for hours, he offered this workout for attendees to take, and then review with him. Prizes went to high-ranking players and free ebooks from O'Reilly Media for everyone. Well, no more prizes, our apologies. But you can still test your PL/SQL knowledge with these quizzes.

Information

  • Instructor

    Steven Feuerstein*

  • Estimated Time

    76 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 Autonomous Transactions (17441)Intermediate5
Quiz on FORALLIntermediate5
Quiz on Sparse Bind Arrays in FORALLAdvanced10
Quiz on Impact of Table Changes on Result CacheIntermediate6
Quiz on Function Result CacheAdvanced18
Quiz on MULTISET OperatorsAdvanced8
Quiz on Returning Multiple Columns Through Table FunctionAdvanced16
Quiz on Suppress DML Errors with LOG ERRORSAdvanced8
Instructor

*About Steven Feuerstein

Steven Feuerstein is a 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, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O'Reilly Media). Steven has been developing software since 1980, spent five years with Oracle (1987-1992), and served as PL/SQL Evangelist for Quest Software between January 2001 and February 2014. He rejoined Oracle in March 2014. Prior to his return to Oracle, Steven was an Oracle ACE Director. He writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. He is also the first recipient of ODTUG's Lifetime Achievement Award (2009), and most recently (2016) was given the Oracle Contributor of the Year Award by ODTUG.

More from Steven Feuerstein