Extract date from string oracle
<p>I have a column in which a string starts with - 'Chicago, IL, April 20, 2015 &mdash; and so on text here'. I want to extract the Date part from this string in Oracle. Any ideas on how to do this. I was able to find something for mm/dd/yyyy like below, but not for long date format.</p>

<pre><code>SELECT REGEXP_SUBSTR(' the meeting will be on 8/8/2008', '[0-9]{1,}/[0-9]{1,}/[0-9]{2,}') FROM dual 
</code></pre>