title: update json value in oracle
body: <p>I have a column in the table which stores data in json format.</p>
  
  <p>Eg. column:</p>
  
  <pre><code>select jsoncol from table; 
  </code></pre>
  
  <p>-- It gives</p>
  
  <pre><code>{"y" : "4", "n" : "0" , "default" : "4"}
  </code></pre>
  
  <p>When i try</p>
  
  <pre><code>select json_value(jsoncol, '$.n') from table;
  </code></pre>
  
  <p>I get the value <strong>0</strong>.</p>
  
  <p>How can I update the value of <strong>n</strong> as <strong>2</strong>, </p>
  
  <pre><code>{"y" : "4", "n" : "2" , "default" : "4"}
  </code></pre>