Another Oracle Dev Gym workout for you...

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.


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

*About Steven Feuerstein

Steven Feuerstein leads a team of Developer Advocate at Oracle Corporation, and is obsessed with the Oracle PL/SQL language, having written ten books on it (all published by O'Reilly Media). He's published over 1400 quizzes on PL/SQL at the Oracle Dev Gym.

More from Steven Feuerstein