DBA Hub

📋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
1

JSON_OBJECT Enhancements

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

JSON_MERGEPATCH

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

JSON_SERIALIZE

The function converts a JSON document from any supported data type to text.
4

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.
5

SQL NESTED Clause Instead of JSON_TABLE

The SQL clause allows us to write the equivalent of the using a simplified syntax.
6

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.
7

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!