Skip to Main Content

SQL & PL/SQL

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
415 views