A Dev Gym Workout

Oracle Database Annual Championship for 2024


This workout offers as exercises all the quizzes that were originally played in Oracle Database Annual Championship for 2024 - 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

    Chris Saxon*

  • Estimated Time

    10 Minutes

  • Difficulty

    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
Returning aggregate types with JSON_VALUE in PL/SQLAdvanced2
Quiz on JSON Flex ColumnsAdvanced2
Updating rows in one to many relationshipsAdvanced1
Returning values from Merge and Update DML StatementsAdvanced3
Displaying and sorting values with domainsAdvanced1
Quiz on Scalar MacrosAdvanced1
Instructor

*About Chris Saxon

Chris Saxon is an Oracle Developer Advocate and quizmaster on Dev Gym. His job is to help you get the best out of the Oracle Database and have fun with SQL! He's also part of the answer team on Ask TOM and creates YouTube videos at The Magic of SQL channel.

More from Chris Saxon