title: ORACLE - JSON To Key Value Pair Table
body: <p>Is there any way to obtain a table with key/value pairs from a CLOB Json Column?</p>
  
  <p>The idea here is to get these values, on a dynamic way. Because the CLOB column does not always contain the same structure.</p>
  
  <p>I've created a function that does this, however since it literally parses the json string, when we use it in a table with many records its very slow. And by very slow I mean like 2-5 records per second, i know it's terrible.</p>
  
  <p>The Oracle tools (v.12c) do not provide a dynamic way to obtain the json tags/values, we have always to specify the paths.</p>
  
  <p>I've been digging all around without any luck. Any thoughts? </p>