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

September 11

17: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 generation from relational data
Beda Hammerschmidt shows how JSON can be be generated form relational tables, for instance to modernize a legacy app.

1:40 - 4:00 Introduction to use case: using S JSON form a relational app
4:25-5:05 turning rows into JSON using JSON_OBJECT
6:00 - 6:40 JSON_ArrayAgg to turn multiple rows into one JSON array
10:00-10:45 Generating nested JSON structure using subqueries
15:40-16:30 JSON object with embedded JSON
28:35-30:30 Updating relational columns from JSON payload
34:00 -end Q/A

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.
Blaine Carter
Blaine Carter, Developer Advocate for Open Source    
Blaine started programming in 1995. For most of his career, he used Oracle software to build applications, including Oracle Forms and Oracle Reports, Java, and a whole lot of SQL and PL/SQL. Now he applies his exploratory eye and tinkering inclinations to the intersection of open source software and Oracle Database.