Json_table Not Returning Correct Data When Used In A Subquery
(Doc ID 2226251.1)
Last updated on APRIL 12, 2022
Applies to:
Oracle Database Backup Service - Version N/A and laterOracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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.
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |