Skip to Main Content

ORDS, SODA & JSON in the Database

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!

Recreate JSON structure from a valid JSON CLOB

Martin J.Apr 6 2020 — edited Apr 15 2020

Hi,

I am in need of a query that can deteremine the JSON structure of a certain column. That column contains a valid JSON structure but each row can be different. I'm looking for a way to find the structure so I can write code to handle that structure. But I have millions of rows in my source table and each row can reveal a different structure (ie. 15 in total, but suppose there is a 16th).

Is there a tool or query that can provide this information?

Regards,

Martin J.

This post has been answered by MaxOrgiyan-Oracle on Apr 13 2020
Jump to Answer

Comments

Processing

Post Details

Added on Apr 6 2020
9 comments
1,133 views