Re: JSON_ARRAY_APPEND adding escape slash
Posted by: Derek McKinnon
Date: August 21, 2022 10:59PM

Here is the place I got the idea for the code from.

https://stackoverflow.com/questions/45674489/mysql-append-json-object-to-array-of-json-objects

Essentially what I'm doing is building a set of data to go out of a stored procedure. To give myself flexibility to attach many items, I am using a JSON array. The array is to be of JSON object types.

I can't find the code for simply taking two JSON Objects (or more) and putting them together in a JSON Array. It seems like a simple request, but it doesn't seem like it is easy.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: JSON_ARRAY_APPEND adding escape slash
36
August 21, 2022 10:59PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.