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 useJSON_DATAGUIDE
: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).
db<>fiddle here
If you have better answer, please add a comment about this, thank you!