A Dev Gym Workout

An Oracle JSON Workout


Oracle Database 12c offers powerful and flexible support for working with JSON inside the database. This workout tests your knowledge of a variety of JSON features in SQL and PL/SQL. Some were introduced in 12.1, others, such as PL/SQL objct types for JSON manipulation, came in 12.2.
  • Instructor

    Steven Feuerstein*

  • Estimated Time

    12 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 JSON_OBJECTIntermediate
Quiz on JSON_VALUEIntermediate
Quiz on JSON_VALUEIntermediate2
Quiz on JSON_TABLEAdvanced6
Quiz on Error Handling With JSON TypesAdvanced2
Quiz on JSON_ARRAY_TIntermediate2
Quiz on JSON_ARRAY_TIntermediate
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