A question cropped up on the Oracle SQL and PL/SQL community forums regarding generating a JSON nested level structure that is hierarchical in nature, from hierarchical data – that typically …| Paulzip's Oracle Blog
This post echoes one of my previous work on the topic, this time applied to JSON data. The idea is to build a user-defined aggregate function to automatically nest a hierarchically-ordered set of J…| Odie's Oracle Blog
At last, a use case where PL/SQL is faster than SQL : avoiding unnecessary ordering !| An Oracle Programmer