clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2591620 fiddles created (45701 in the last week).

with t as ( select '{"a":1, "b": [{"b1":2}, {"b2": "z"}]}' js from dual ) select json_query (js, '$' returning varchar2 (4000) pretty) prettyjson, js from t
PRETTYJSON JS
{ "a" : 1, "b" : [ { "b1" : 2 }, { "b2" : "z" } ] } {"a":1, "b": [{"b1":2}, {"b2": "z"}]}
 hidden batch(es)