Return a resultset as JSON text—using pretty formatting

Question

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 db<>fiddle:

enter image description here

Question:

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

{
 "DUMMY":"X"
}

Related: Select JSON text of SDO_GEOMETRY using SQL

Answer 1

As documented, you can add PRETTY to a JSON function to prettify it

SELECT json_object(* PRETTY)
from dual;

db<>fiddle

Output

{
 "DUMMY" : "X"
}