Skip to Main Content

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!

Question on JSON data

User_CI7SYOct 16 2021

Hi Team, I have one json_array_t(variable =ARR) with value given below and I want to make one json data type(variable=FINAL_J) using this value and adding one key to the array .Could you please help me understand which json data type to be used here and how to create that? Will it be json_element_t?
ARR := JSON_ARRAY_T('[{"Address1":"3121,"Address2":"Suite 301"},{"Address1":"3121","Address2":"Suite 301"}]');
FINAL_J = '{"distributors":[{"Address1":"3121,"Address2":"Suite 301"},{"Address1":"3121","Address2":"Suite 301"}] }'

Comments
Post Details
Added on Oct 16 2021
2 comments
113 views