title: How to parse json in oracle sql? (Version:11.2.0)
body: <p>I saved json data to a field in the database.I want to parse the json file with Oracle . How can I do it?</p>
  <pre class="lang-json prettyprint-override"><code>{
    &quot;widget&quot;: {
      &quot;debug&quot;: &quot;on&quot;,
      &quot;window&quot;: {
        &quot;title&quot;: &quot;Sample Konfabulator Widget&quot;,
        &quot;name&quot;: &quot;main_window&quot;,
        &quot;width&quot;: 500,
        &quot;height&quot;: 500
      },
      &quot;image&quot;: {
        &quot;src&quot;: &quot;Images/Sun.png&quot;,
        &quot;name&quot;: &quot;sun1&quot;,
        &quot;hOffset&quot;: 250,
        &quot;vOffset&quot;: 250,
        &quot;alignment&quot;: &quot;center&quot;
      },
      &quot;text&quot;: {
        &quot;data&quot;: &quot;Click Here&quot;,
        &quot;size&quot;: 36,
        &quot;style&quot;: &quot;bold&quot;,
        &quot;name&quot;: &quot;text1&quot;,
        &quot;hOffset&quot;: 250,
        &quot;vOffset&quot;: 100,
        &quot;alignment&quot;: &quot;center&quot;,
        &quot;onMouseUp&quot;: &quot;sun1.opacity = (sun1.opacity / 100) * 90;&quot;
      }
    }
  }
  </code></pre>