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!

Json_Table nested array

Rahul BAJun 21 2023 — edited Jun 21 2023

Hi All,

Needed help reading the data from json in the below format using json_table function

Note that data inside the test2UUIDS are dynamic. I will not know how many key:value pairs will present.

[

{
"test1UUIDs": {},
"test2UUIDs": {
"1": "aaaaaa",
"2": "bbbbb"
},

{
"test1UUIDs": {},
"test2UUIDs": {}

]

Added on Jun 21 2023

6 comments

484 views