Getting to grips with JSON in the database

With Oracle 23c, JSON in the database is now a reality.  Mixing relational and JSON in the database is becoming mainstream.

In this session, using practical examples in the Oracle Cloud, we'll look at:

Generating JSON objects from relational data using SQL and PL/SQL

⁃ JSON_OBJECT

⁃ json object types

⁃ apex_json

Using JSON objects in PL/SQL

⁃ dot notation

⁃ parsing JSON

⁃ json_table

⁃ json_query

Presenting JSON objects as relational

⁃ relational joins with JSON data

Manipulating and updating JSON objects from PL/SQL

⁃ json_transform

Indexing JSON data

⁃ simple index

⁃ multi-value indexes

⁃ search indexes

The new JSON Relational Duality view feature

⁃ creating a JSON Relational Duality View

⁃ Changing relational data via JSON

⁃ ETAG and locking