title: Oracle to select all matched occurrences by a regular expression to one column in one row with separator
body: <p>I know to select all matched occurrences by a regular expression to one column in multiple rows as below:</p>
  
  <pre><code>SELECT REGEXP_SUBSTR(str, '\+?\d{3,11}', 1, LEVEL) AS substr
  FROM (
      SELECT 'Txa233141b Ta233141 Ta233142 Ta233147 Ta233148' AS str FROM DUAL
  )
  CONNECT BY LEVEL &lt;= LENGTH(REGEXP_REPLACE(str, '[^ ]+')) + 1;
  </code></pre>
  
  <p>the result is </p>
  
  <pre><code>233141
  233141
  233142
  233147
  233148
  </code></pre>
  
  <p>But I want to the result as below, what can I do?</p>
  
  <pre><code>233141,233141,233142,233147,233148
  </code></pre>