Skip to Main Content

JSON in Oracle Database Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

June 19

17:00 UTC   Start Times Around the World


JSON Data Guide
Identifying and Cleaning Up JSON Messes: JSON documents are “schema-less”, meaning developers can stuff whatever they want into them. But that can lead to all sorts of inconsistencies and other data integrity issues. JSON Dataguide to the rescue! In this session, Beda Hammerschmidt shows how to use Oracle’s unique Dataguide feature, combined with the JSON_TABLE function, to make it easy to perform analytics on your JSON variants.

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.

Your Experts

Beda Hammerschmidt
Beda Hammerschmidt, Consulting Member of Technical Staff    
Beda is a developer (and self-proclaimed developer advocate) in the JSON team. Ask him anything JSON.
Steven Feuerstein
Steven Feuerstein, Developer Advocate for PL/SQL    
Steven Feuerstein is a Senior Advisor at Insum Solutions (, 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!