clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
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. 2335496 fiddles created (27409 in the last week).

select json_object(key 'a' value 1, key 'b' value null null on null) c1 ,(SELECT json_object(key 'a' value 1, key 'b' value null absent on null) FROM dual) c2 from dual
C1 C2
{"a":1,"b":null} {"a":1}
 hidden batch(es)


select json_object(key 'a' value 1, key 'b' value null null on null) c1, json_object(key 'a' value 1, key 'c' value null absent on null) c2 from dual;
C1 C2
{"a":1,"b":null} {"a":1}
 hidden batch(es)