I have been came across requirement for printing nested JSON in one of the application. Using APEX_JSON, there is no straight forward way – I can just print a cursor or ref-cursor to an output as nested JSON. So, I have to write a pl/sql block and manually build JSON output. Purpose of this blog …