Oracle’s JSON_TABLE provides a facility to un-nest arrays using the nested path clause, but if you try to use that with sibling arrays you can end up with unexpected results. In my previous post JSON Sibling Arrays – Without Ordinal Association, I covered the situation where sibling arrays have no connection through ordinal position, they … Continue reading JSON Sibling Arrays – With Ordinal Association| Paulzip's Oracle Blog
Oracle’s JSON_TABLE provides a facility to un-nest arrays using the nested path clause, but if you try to use that with sibling arrays you can end up with unexpected results. Sibling arrays here mean separate arrays, but at the same level under the same parent object. There are two types of sibling array scenarios: 1. … Continue reading JSON Sibling Arrays – Without Ordinal Association| Paulzip's Oracle Blog