Updating oracle clob
Nothing happens if the path does not target any item.
The following procedures append a single value of the corresponding data type to each JSON array targeted by the path expression.
Note that if you use '' (empty string) in INSERT statement, Oracle will insert NULL: Oracle: Server, you can also specify a string literal to insert a value into a CLOB column.
To insert an empty value you can just use '' (empty string constant).
Nothing happens if the path does not target any JSON object.
If the path targets a JSON array item then that item is removed from the array.
Note that you may need to replace '' used in INSERT statements for Oracle with NULL in INSERT statements for In Oracle, you can use LENGTH() or DBMS_LOB.