title: How to update a part of JSON string in Oracle 12c?
body: <p>I've a table in my oracle DB as below.</p>
  
  <pre><code>CREATE TABLE my_table(
    id    RAW(16) NOT NULL,
    data  CLOB,
    CONSTRAINT my_table_pk PRIMARY KEY (id),
    CONSTRAINT my_table_json_chk CHECK (data IS JSON)
  );
  
  
  INSERT INTO my_table (id, data)
  VALUES (SYS_GUID(),
          '{
            "FirstName"      : "aa",
            "LastName"       : "bb",          
            "Address"        : {
                                "Street"   : "99 My Street",
                                "City"     : "My City",
                                "Country"  : "UK",
                                "Postcode" : "A12 34B"
                               }');
  </code></pre>
  
  <p>Now I know, I can fetch value of a specific property like <code>address</code> of the JSON string using $. </p>
  
  <p>Similarly, can I update <code>Street</code> property of the JSON string without providing the entire JSON structure in my update query?</p>
  
  <p>Please help me on this.</p>