Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is there a way to parse unknown depth level of nested json?

ronald_2017Mar 23 2022

Hello All,

I use Oracle 19c, I am just wondering that is there any way to parse unknown depth level of nested json? Let's say that we don't know the height tree of response json. I use JSON_TABLE function. For example, if it could be used loop inside JSON_TABLE function, it would probably solved this issue.

Thanks

This post has been answered by Paulzip on Mar 24 2022
Jump to Answer
Comments
Post Details
Added on Mar 23 2022
2 comments
1,010 views