title: SQL - receiving multiple patterns from a string
body: <p>Lets say I have a 2 column table, in 1st col. is an account number and in the 2nd personal client ID BUT in a long string. In that string may be few different clients IDs and each begins with "ID"</p>
  
  <pre><code>|account_no  | note
  |12345       | AAAAID1111BBBBID2222CCACAID3333JDBSTGDid4444
  </code></pre>
  
  <p>How can I receive such result each in single row?:</p>
  
  <pre><code>account_no|ID
  12345      1111
  12345      2222
  ...
  1234       4444
  </code></pre>
  
  <p>using <code>regexp_substr(upper(note), 'ID[[:digit:]]{4}')</code> it returns me only first ID from the whole string. </p>
  
  <p>Any loop or is there any trick with regexps?</p>