New Oracle SQL Function JSON_TRANSFORM

You can use SQL function JSON_TRANSFORM to update parts of a JSON document. You specify which parts to modify, the modifications, and any new values.

JSON_TRANSFORM makes it easier for an application to modify a JSON document, without having to parse and rebuild it. In most cases, it also avoids a round-trip between the server and client for the whole document.

Related Topics