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

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

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:

db<>fiddle

Question:

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

{
   "DUMMY":"X"
}

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