Json_table Not Returning Correct Data When Used In A Subquery
Last updated on APRIL 19, 2018
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
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.
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