JSON-Relational Duality Views (23.4) Create a JSON interface for relational tables Define using SQL or GraphQL style syntax The database converts DML using JSON objects on the view to the relational tables Example duality view created using GraphQL syntax
JSON-Relational Duality Views (23.4) Example inserting JSON into a duality view and showing it writes to the underlying database tables
With JSON Relational duality views in Oracle AI Database 26ai you can
Define a #JSON API over tables using #SQL or GraphQL
Read & write JSON data; the database translates this to relational tables
This gives you the benefit of
Normalized data storage
Simple JSON data access