Search notes:

Oracle: JSON_TRANSFORM

update
   tq84_json_docs
set
   jsn = json_transform(jsn,
           set    '$.foo.bar' = 'baz',
           remove '$.list[*]?(@.type == "xyz")'
                                          )
where
  …

Modification operations for json_transform are

remove
keep
rename
set
replace
insert
append

(Optional) handlers:

{error|ignore|replace|remove} on existing

{error|ignore|create} on missing

{null|error|ignore|remove} on null

Not all handlers are possible for a given operation.

Oracle: JSON_TRANSFORM

See also