title: How do you index an array inside a JSON with an Oracle 12c query?
body: <p>I have a table "move" with one column "move_doc" which is a CLOB. The json stored inside has the structure:</p>
  
  <pre><code>{
  moveid : "123",
  movedate : "xyz",
  submoves: [
  {
  submoveid: "1",
  ...
   },
  {
  submoveid : "2",
  ...
  }
  ]
  }
  </code></pre>
  
  <p>I know I can run an Oracle 12c query to access the submoves list with:</p>
  
  <p><code>select move.move_doc.submoves from move move</code></p>
  
  <p>How do I access particular submoves of the array? And the attributes inside a particular submove?</p>