My Oracle Support Banner

New Features in 18.1 JSON Database - (Doc ID 2357879.1)

Last updated on JUNE 12, 2021

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Purpose

 To document the new features available from 18.1 JSON Database.

Scope

 All Database Administrators or JSON developers using 18.1

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 SQL Enhancements
 You Can Specify That a SQL Expression Returns JSON Data
 LOB Results for JSON_VALUE, JSON_QUERY, and JSON_TABLE
 SQL/JSON Generation Function Enhancements
 Item Methods for SQL/JSON Path Expressions
 JSON Data Guide Enhancements
 Data-Dictionary Views That Record the Presence of JSON Columns
 SQL/JSON Function JSON_TABLE Syntax
 ON STATEMENT Support For JSON_TABLE Materialized Views
 New SQL Function TO_UTC_TIMESTAMP_TZ
 New Oracle SQL Condition JSON_EQUAL
 
Sharding Support
 
Performance Improvements for LOB Storage
 
JSON Search Index Support for Longer Field Names
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.