title: Oracle Using JSON_VALUE to get Array Property JSON returnning NULL
body: <p>I need to get the value of property x, but, aways return null</p>
  
  <p>This doesn't work:</p>
  
  <pre><code>SELECT JSON_VALUE('[{a:100}, {b:200}, {c:[{xico:1}]}]', '$.c') AS value
    FROM DUAL; 
  </code></pre>
  
  <p>This works:</p>
  
  <pre><code>SELECT JSON_VALUE('[{a:100}, {b:200}, {c:[{xico:1}]}]', '$.a') AS value
    FROM DUAL; 
  </code></pre>
  
  <p>and returns 100</p>
  
  <p>how can I retrieve or c property array using JSON_VALUE?</p>