Oracle: return rows in JSON format?

Question

Is there a way to tell Oracle to return rows from a query in the form of a JSON string?

For example,

select 11,'abc' from dual;

would return

[11,"abc"]

eaolson · Accepted Answer · 2012-11-15 02:03:28Z

4

There's no simple function, no. There is PL/JSON at Sourceforge. Also, this ORA-0001 blog post demonstrates a method using XML (way down the page).

answered Nov 15, 2012 at 2:03

eaolson

15.2k7 gold badges46 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

The ORA-0001 method looks like it does just the right thing. Thanks!