SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JSON to sql result set

AAGMay 12 2015 — edited May 13 2015

Hi All,

I have this requirement to convert JSON format into result set (with rows and columns).

is their anyway i can get to this?

I was successfully able to convert sql result set to JSON format but having hard time to do vice versa.

Flexibility:

At any Given point, i am expecting the rows to be returned not more than 2 & around 50 columns at max.

Therefore, the JSON itself can be stored in varchar2(4000) and not require CLOB to be used. (If required to be passed as an argument to the function).

On Oracle version: 11.2.0.3

Regards,

AAG

This post has been answered by chris227 on May 13 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 10 2015

Added on May 12 2015

#11g, #xml

4 comments

1,303 views