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

Restrict File Upload by File Type in Oracle Apex

If you want to restrict file upload by file type/extension/format you can follow the below steps.  Goto File Browser Item --> Advanced --...