Question:does a function exist (or how to create such a function) that take a json element and return the structure.
For instance, I would like a function f that in this case :
Answer:From Oracle 12.2, You can use
PATH TYPE $ array $.a number $.b array $.b[*] string $.b.a number
If you want something more detailed then you are probably going to have to write your own JSON parser in PL/SQL (or Java and compile it in the database).
If you have better answer, please add a comment about this, thank you!