By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| XMLTYPE.CREATEXML(DBMS_XMLGEN.GETXML('SELECT2ASAFROMDUAL')) |
|---|
| <?xml version="1.0"?> <ROWSET> <ROW> <A>2</A> </ROW> </ROWSET> |
| JSON_ARRAYAGG(JSON_OBJECT(T.*)) |
|---|
| [{"A":1}] |