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:

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"
}