create table tjson ( jsoncol CLOB CONSTRAINT tjson_chk CHECK (jsoncol IS JSON) )Table created.
insert into tjson (jsoncol) VALUES ( '{"y" : "4", "n" : "0" , "default" : "4"}')1 row(s) inserted.
select json_mergepatch (jsoncol, '{"n" : "2"}') as new_json from tjson| NEW_JSON | {"y":"4","n":"2","default":"4"} |
|---|