8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
JSON Support Enhancements in Oracle Database 19c
Oracle 19c includes several enhancements to the JSON functionality in the database. This post acts as a links page to separate articles on each feature.
- JSON_OBJECT Enhancements
- JSON_MERGEPATCH
- JSON_SERIALIZE
- Mapping of JSON Data To and From SQL Object Types
- SQL NESTED Clause Instead of JSON_TABLE
- GeoJSON Data Support
- Materialized View Support for Queries containing JSON_TABLE
JSON_OBJECT Enhancements
The SQL/JSON function JSON_OBJECT got a whole lot easier to use in Oracle 19c.
JSON_MERGEPATCH
The JSON_MERGEPATCH
function is used to modify parts of a JSON document in select and update operations.
JSON_SERIALIZE
The JSON_SERIALIZE
function converts a JSON document from any supported data type to text.
Mapping of JSON Data To and From SQL Object Types
Oracle database 19c allows JSON data to instantiate user-defined object type instances, and user defined object-type instances can be converted to JSON data.
SQL NESTED Clause Instead of JSON_TABLE
The SQL NESTED
clause allows us to write the equivalent of the LEFT OUTER JOIN JSON_TABLE
using a simplified syntax.
GeoJSON Data Support
In this article we demonstrate the support for GeoJSON data in Oracle Database 19c. Specifically the mapping between GeoJSON data and the Oracle Spatial SDO_GEOMETRY
object type.
Materialized View Support for Queries containing JSON_TABLE
Oracle 19c can perform query rewrites of statements using some SQL/JSON functions (JSON_VALUE
, JSON_EXISTS
) to use a materialized view containing and appropriate JSON_TABLE
call.
For more information see:
- JSON_OBJECT Enhancements in Oracle Database 19c
- JSON_MERGEPATCH in Oracle Database 19c
- JSON_SERIALIZE in Oracle Database 19c
- Mapping of JSON Data To and From SQL Object Types in Oracle Database 19c
- SQL NESTED Clause Instead of JSON_TABLE in Oracle Database 19c
- GeoJSON Data Support in Oracle Database 19c
- Materialized View Support for Queries containing JSON_TABLE in Oracle Database 19c
- JSON Quick Links : Introduction, 12cR1, 12cR2, 18c, 19c, 21c, 23c, All Articles
Hope this helps. Regards Tim...