title: PLSQL turn clob containing json into table
body: <p>Is there a way to turn a clob  containing JSON Object into table</p>
  <p>for example I have a clob containing [{&quot;a&quot;:&quot;1&quot;,&quot;b&quot;:&quot;1&quot;; &quot;a&quot;:&quot;2&quot;, &quot;b&quot;:&quot;2&quot;; &quot;a&quot;:&quot;2&quot;,&quot;b&quot;:&quot;2&quot;}]
  I want to turn this into a table to join it with other tables in my database.</p>
  <p>is there a way to do it?</p>
  <p>Thank you!</p>