JSON in the Oracle Database (19c)

JSON is the exchange format of modern interfaces. Oracle 19c can store, query and generate JSON completely without giving up the relational world. The workshop shows how both work together cleanly.

Audience

SQL and PL/SQL developers who process interfaces, configurations or documents as JSON.

Modules

The modules are building blocks. You choose and weight them, and we agree on the agenda together beforehand.

• Storage: JSON in VARCHAR2, CLOB and BLOB, IS JSON constraints, choosing the format
• Querying: dot notation, JSON_VALUE, JSON_QUERY, JSON_EXISTS, JSON_TABLE
• Generating: JSON_OBJECT, JSON_ARRAY, JSON_OBJECTAGG, JSON_ARRAYAGG
• Indexing: function-based indexes, JSON search index, data guide
• PL/SQL: JSON_OBJECT_T and friends, modifying and validating JSON
• Hands-on: loading CSV and foreign formats with JSON_TABLE, processing REST responses
• Outlook: what moving to 26ai brings

Outcome

Patterns and scripts for JSON processing in your 19c environment, aligned with your interfaces.

Preview

For a first look: the talks on this topic give you an overview, and the talk pages include the slides.

• JSON, the Database and I RMOUG Training Days 2023
• Parse CSV Files with Pure SQL & the Magic of JSON_TABLE RMOUG Training Days 2017