title: Convert JSON in a format can be read by JSON_VALUE in oracle
body: <p>I have JSON data in format -</p>
  <pre class="lang-json prettyprint-override"><code>{&quot;dims&quot;:{&quot;ABC&quot;:{&quot;dim&quot;:&quot;ABC&quot;,&quot;bins&quot;:{&quot;1290&quot;:{&quot;bin&quot;:&quot;1290&quot;,&quot;hits&quot;:&quot;1&quot;,&quot;first_date&quot;:&quot;03.11.15&quot;},&quot;345&quot;:{&quot;bin&quot;:&quot;345&quot;,&quot;hits&quot;:&quot;2&quot;,&quot;first_date&quot;:&quot;03.11.15&quot;},&quot;6603&quot;:{&quot;bin&quot;:&quot;6603&quot;,&quot;hits&quot;:&quot;1&quot;,&quot;first_date&quot;:&quot;23.12.15&quot;},&quot;6609&quot;:{&quot;bin&quot;:&quot;6609&quot;,&quot;hits&quot;:&quot;1&quot;,&quot;first_date&quot;:&quot;13.12.15&quot;}}}}}
  </code></pre>
  <p>How can I convert it into a format -</p>
  <pre class="lang-json prettyprint-override"><code>{&quot;dims&quot;:{&quot;BINDUNGS_ID_CARDS&quot;:{&quot;dim&quot;:&quot;BINDUNGS_ID_CARDS&quot;,&quot;bins&quot;:[{&quot;bin&quot;:&quot;1290&quot;,&quot;hits&quot;:&quot;1&quot;,&quot;first_date&quot;:&quot;03.11.15&quot;},{&quot;bin&quot;:&quot;345&quot;,&quot;hits&quot;:&quot;2&quot;,&quot;first_date&quot;:&quot;03.11.15&quot;},{&quot;bin&quot;:&quot;6603&quot;,&quot;hits&quot;:&quot;1&quot;,&quot;first_date&quot;:&quot;23.12.15&quot;},{&quot;bin&quot;:&quot;6609&quot;,&quot;hits&quot;:&quot;1&quot;,&quot;first_date&quot;:&quot;13.12.15&quot;}]}}}
  </code></pre>
  <p>I want to read it from oracle using JSON_VALUE function via  <code>JSON_VALUE(value, $.*.*.bins[0])</code>.</p>
  <p>I have no idea how can i achieve it via oracle.</p>