Oracle extract json fields using regular expression with oracle regexp_substr
<p>I'm using Oracle query with <strong>regular expression</strong> and oracle <strong>regexp_substr</strong> to extract json fields from <strong>JSON</strong> string.</p>

<p>whene I try to get the value of code key it working well and its value, but whene i try to get the value of results key it return null.</p>

<p>I'm using this query:</p>

<pre><code>select regexp_replace(regexp_substr('{"code":"001","message":"success","transactionId":437,"results":{"name":"osama"}}','"results":\s*("(\w| )*")', 1, level), '"results":\s*"((\w| )*)"', '\1', 1, 1) results
 from dual
connect by regexp_substr('{"code":"001","message":"success","transactionId":437,"results":{"name":"osama"}}', '"results":\s*("(\w| )*")', 1, level) is not null;
</code></pre>

<p>What is wrong in this query? 
Thanks</p>