Return a resultset as JSON text—using pretty formatting

2 votes

1 answer

1130 views

                          In Oracle 21c, it looks like we can return a resultset as JSON text:

    SELECT json_object(*)
    from dual;
    
    result:
    {"DUMMY":"X"}

That works in dbfiddle :

**Question:**

Is there a way to return the JSON text using pretty formatting?

    {
       "DUMMY":"X"
    }

Related: Select JSON text of SDO_GEOMETRY using SQL

Asked by User1974 (1527 rep)

Jan 2, 2022, 05:24 PM
Last activity: May 2, 2022, 02:54 PM

Return a resultset as JSON text—using pretty formatting

Related Questions