8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23ai | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
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
- JSON_SCALAR Function
- JSON_TRANSFORM Function
- Multivalue Function-Based Indexes for JSON_EXISTS
Related articles.
- JSON Quick Links : Introduction, 12cR1, 12cR2, 18c, 19c, 21c, 23c, All Articles
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:
- JSON Data Type in Oracle 21c
- JSON_SCALAR Function
- JSON Quick Links : Introduction, 12cR1, 12cR2, 18c, 19c, 21c, 23c, All Articles
Hope this helps. Regards Tim...