DBA Hub

📋Steps in this guide1/4

JSON Support Enhancements in Oracle Database 21c

Oracle 21c includes several enhancements to the JSON functionality in the database. This post acts as a links page to separate articles on each feature.

oracle 21cconfigurationintermediate
by OracleDba
11 views
1

JSON Data Type

The data type was introduced in the Oracle 20c preview release to provide native JSON support and improve the performance of JSON processing. It has become generally available in Oracle 21c.
2

JSON_SCALAR Function

The function creates an instance of a type from a SQL scalar value.
3

JSON_TRANSFORM Function

The function creates an instance of a type from a SQL scalar value.
4

Multivalue Function-Based Indexes for JSON_EXISTS

Multivalue function-based indexes allow us to index multiple scalar values in JSON documents stored in the JSON data type. For more information see: Hope this helps. Regards Tim...

Comments (0)

Please to add comments

No comments yet. Be the first to comment!