📋Steps in this guide1/7

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.

oracle 19cconfigurationintermediate

by OracleDba

22 views

JSON_OBJECT Enhancements

The SQL/JSON function JSON_OBJECT got a whole lot easier to use in Oracle 19c.

JSON_MERGEPATCH

The function is used to modify parts of a JSON document in select and update operations.

JSON_SERIALIZE

The 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 clause allows us to write the equivalent of the 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 object type.

Materialized View Support for Queries containing JSON_TABLE

Oracle 19c can perform query rewrites of statements using some SQL/JSON functions ( , ) to use a materialized view containing and appropriate call. For more information see: Hope this helps. Regards Tim...

Comments (0)

Please to add comments

No comments yet. Be the first to comment!