relationaljson

Demo 10 - Working with JSON and Relational data together

module relationaljson

• Loading JSON data inside a Simple Oracle Document Access OracleCollection with client-side OSON* encoding
• Unnesting JSON arrays into relational rows using the SQL standard function JSON_TABLE... in fact its simpler syntax NESTED <JSON column>
• Creating new JSON documents with the SQL standard JSON_OBJECT function
• Joining JSON fields with Relational columns to leverage all the power of SQL

* see also:

• Autonomous JSON Database under the covers: OSON format