JSON - 19c New Features
Introduction
There are some new JSON features which in a multi-model environment will no doubt be welcome.
Materialized View Support for Queries
Queries using JSON_TABLE with the following functions can now use materialized view
JSON_EXISTS
JSON_VALUE
JSON Update
JSON documents can now be updated using the SQL function JSON_MERGEPATCH
This allows single or multiple updates to one or more documents.
SQL/JSON Syntax Simplifications
Syntax has been simplified for field projection, path expressions and the generation function JSON_OBJECT.
The full extent of these improvements can be found here
Other new features
The following new features
- JSON Object Mapping
- New SQL/JSON Function JSON_SERIALIZE and JSON Data Guide Support for GeoJSON Data. Find out more details here
Published 20th April 2023
