title: Oracle 11g get all matched occurrences by a regular expression
body: <p>I'm using Oracle 11g and I would like to use the REGEXP_SUBSTR to match all the occurrences for a given pattern.
  For example</p>
  
  <pre><code> SELECT
    REGEXP_SUBSTR('Txa233141b Ta233141 Ta233142 Ta233147 Ta233148',
    '(^|\s)[A-Za-z]{2}[0-9]{5,}(\s|$)') "REGEXP_SUBSTR"
    FROM DUAL;
  </code></pre>
  
  <p>returns only the first match Ta233141  but I would like to return the other occurrences that match the regex, meaning Ta233142 Ta233147 Ta233148.</p>