Getting to grips with JSON in the database

Track B 12:55 - 13:40
Težavnost: Intermediate
Področje: Database development
Jezik: Angleščina

With Oracle 21c and 23c, JSON in the database is now a reality. Mixed relational-JSON databases are on the verge of 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

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.

Speaker:
Niall Mc Phillips
Podjetje
Long Acre