How can I parse JSON string in PL/SQL
<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>