title: What is the best way to separate and save addresses from a string in PL/SQL?
body: <p>In our database we have tables with company addresses. 
  Some companies have more than 1 address. In this case we used to save addresses in a column like that: </p>
  
  <pre><code>'119021, г Москва, ул Льва Толстого, д 16; 117312, г Москва, ул Вавилова, д 19' 
  </code></pre>
  
  <p>So there are a semicolon and space between addresses.</p>
  
  <p>Now I have to create different table where every address has its own row by copying data from existing table. </p>
  
  <p>What instruments should I use in my procedure that</p>
  
  <ul>
  <li>determine whether there are one or more than 1 addresses in a column</li>
  <li>separate addresses if there are more than 1</li>
  </ul>
  
  <p>Should I use REGEXP? If yes, how? </p>