Getting to grips with JSON in the database


EMEA Community Tour

Date and time

Thursday, 19. October 2023., 15:00


Hall C



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 types



Using JSON objects in PL/SQL

 dot notation

 parsing JSON




Presenting JSON objects as relational

 relational joins with JSON data


Manipulating and updating JSON objects from PL/SQL



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

Lecture details

Type: Lecture
Level of difficulty: Detailed
Desirable listeners function: Developers , DBA
Group of activity: EMEA Community Tour

About speaker

T-Shirt Sponsor

Venue Sponsor

Media Sponsor

The conference is organized by the Croatian Association of Oracle users. More about the association can be found at

Linkedin HrOUG

Follow us on Linkedin

Follow us on Twitter

Follow us on Facebook