8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » 21c » Here

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.

JSON Data Type

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

JSON_SCALAR Function

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

JSON_TRANSFORM Function

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

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

Back to the Top.