title: Oracle - Extract multiple substrings from a string
body: <p>I need to extract all e-mail accounts mentioned on a single string, so far I've tried with <code>SUBSTR</code> and <code>INSTR</code>, but with no success, here an example:</p>
  
  <p>The string looks like this:</p>
  
  <pre><code>()
  string = "User_1" {user_1@domain.com};"User_2" {user_2@domain.com};"User_3" {user_3@domain.com};"User_4" {user_4@domain.com};
  
  
  select SUBSTR(string ,INSTR(string ,'&lt;',-1,2)) EMAIL
  from dual;
  </code></pre>
  
  <p>What I need is something like this:</p>
  
  <pre><code>user_1@domain.com;user_2@domain.com;user_3@domain.com;user_4@domain.com;
  </code></pre>