title: How to convert a JSON array into a set of rows in Oracle?
body: <p>I want to convert a json array into a set of rows in Oracle.</p>
  
  <p>Input:</p>
  
  <pre><code>'["a","b","c"]'
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>col_name
  ---------
  a
  b
  c
  </code></pre>
  
  <p>PostgreSQL provides the function, <em>jsonb_array_elements(jsonb)</em> to do this.</p>
  
  <p>How can I do this in Oracle 18c. Thank you.</p>