title: How to fetch the multiple match string using a regular expression
body: <p>My string <code>2711393|2711441|1234567</code></p>
  
  <p>My query is:</p>
  
  <pre><code>SELECT REGEXP_SUBSTR('2711393|2711441|2711441', '([0-9]{7})') from DUAL;
  </code></pre>
  
  <p>Actual output is <code>2711393</code>.</p>
  
  <p>Expected output is <code>2711393, 2711441, 2711441</code>.</p>