Json_table Not Returning Correct Data When Used In A Subquery

(Doc ID 2226251.1)

Last updated on APRIL 19, 2018

Applies to:

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

Symptoms

The following query with JSON_TABLE returns correct result:


Both queries above should return the same result, i.e. 'X', since in both cases, the query is checking for the same row.

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms