Search This Blog

Saturday, February 4, 2023

Merging New Json with Existing Json

Merging Json:

SELECT  json_mergepatch(Table.ExistingJsonColumn, '{"EXPANSE_DATA": {"MONTH" : { "JAN" : { "AMOUNT" : 2000}}}}') FROM Table

No comments:

Post a Comment

Search String Inside Oracle Database Objects SQL

SELECT owner, name, type, line, text  FROM dba_source WHERE instr(UPPER(text), UPPER('string')) > 0;