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

Java to Oracle database Connection Using JDBC

Oracle database. // Java Program to Establish Connection  // in JDBC with Oracle Database // Importing database import java.sql.*; // Import...