Generate JSON From Relational Data

Held on September 2018

Beda Hammerschmidt shows how JSON can be be generated form relational tables, for instance to modernize a legacy app. Lots of live demos!

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

AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.