title: How to convert json to columns and rows using oracle table function
body: <p>I have a table structure as below:</p>
  <pre><code>create table json_tab (id number constraint primary key,d_data clob(30000));
  
  insert into json_tab values (1,'[{&quot;a&quot;=0,&quot;b&quot;=1},{&quot;a&quot;=1,&quot;b&quot;=2},{&quot;a&quot;=2,&quot;b&quot;=3}]');
  insert into json_tab values (2,'[{&quot;a&quot;=0,&quot;b&quot;=1},{&quot;a&quot;=1,&quot;b&quot;=2},{&quot;a&quot;=2,&quot;b&quot;=3}]');
  </code></pre>
  <p>I want to write a query to fetch records as below format.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>id</th>
  <th>a</th>
  <th>b</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>0</td>
  <td>1</td>
  </tr>
  <tr>
  <td>1</td>
  <td>1</td>
  <td>2</td>
  </tr>
  <tr>
  <td>1</td>
  <td>2</td>
  <td>3</td>
  </tr>
  <tr>
  <td>2</td>
  <td>0</td>
  <td>1</td>
  </tr>
  <tr>
  <td>2</td>
  <td>1</td>
  <td>2</td>
  </tr>
  <tr>
  <td>2</td>
  <td>2</td>
  <td>3</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Above is an example data. Real data is for JSON column more than 30000 bytes</p>