My Oracle Support Banner

Add SQL/JSON Generation Function Options: EMPTY STRING ON NULL (23ai and later) (Doc ID 3021938.1)

Last updated on MAY 23, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 23.4 and later
Oracle Database - Standard Edition - Version 23.4 and later
Information in this document applies to any platform.

Goal

Oracle Database 23ai adds a new SQL NULL-handling option: "EMPTY STRING ON NULL" that uses JSON generation functions from relational data to generate JSON data.

Solution

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
Goal
Solution

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