Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

how to combine two JSON array list into single array list

Kannan SekarMar 2 2022

We are using Oracle 19C version. we have json like below,
{ "tktKey": "123456", "attlist1": [ { "attkey": "123", "attval": "abc" }, { "attkey": "456","attval": "def" } ], "attlist2": [{"attkey": "098", "attval": "xyz" } ]}
form above json i need to combine attlist1 and attlist2 and make it to single attlist.
The Excepted output should be like below,
{ "tktKey": "123456", "attlist": [ { "attkey": "123", "attval": "abc" }, { "attkey": "456", "attval": "def" }, { "attkey": "098", "attval": "xyz" } ]}

Comments
Post Details
Added on Mar 2 2022
11 comments
3,875 views