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

March 09, 2021

18:00 UTC   Start Times Around the World

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.


JSON Workshop with Jeff Smith
The JSON Workshop is a browser-based UI to work with JSON data in SODA collections stored in an Autonomous database (ATP, AJD).
Jeff Smith will give an overview into it's features and how common tasks are simplified using this tool

0 Intro
4:00 Database Actions (Sql Developer Web)
5:45 "Stupid Pet Tricks": Jeff's Twitter feed
7:30 find JSON tweets using the SODA Api
9:40 "Query By Example"
10:50 SQL Query using JSON_Exists
12:15 ORDS: Oracle Rest Data Services
14:20 Tour: SQL Developer Web
19:20 Json Data loading
22:50 JSON interface/editor
29:00 JSON Schema visualization
32:00 finding tweets
36:40 SODA REST interface
38:10 How to get rewritten SQL for a SODA query
38:40 Explain plan for SODA query
42:00 Preview new features
47:30 Answering QA
52:00 Jeff's blog

Your Experts

    Beda Hammerschmidt

    Beda Hammerschmidt   

    Beda is a developer (and self-proclaimed developer advocate) in the JSON team. Ask him anything JSON.
    That Jeff Smith

    That Jeff Smith   

    Jeff is a Product Manager for Oracle, working on the SQL Developer team. His true passion lies in helping people maximize their productivity and retain sanity while working with database development and administration tools, such as SQL Developer, ORDS and SQLcl.