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" } ]}