title: How can I parse JSON string in PL/SQL
body: <p>I want to parse a JSON string that is in the CLOB column from table Tests_1, and insert it into another table (Test_2).</p>
  
  <p>How can I do this in PL/SQL without using any JSON library?</p>
  
  <pre><code>create table Tests_1
  (
    value   CLOB
  )
  create table Test_2 (a date,b date,c number,d number, e number)
  
  INSERT INTO Tests_1
    (value)
  VALUES
    ('{ 
  "a":"01/01/2015",
  "b":"31/12/2015",
  "c":"11111111111",
  "d":"1111111111",
  "e":"1234567890"
  }');
  </code></pre>