title: Make a query to split a line into x line depending on a field
body: <p>I got a line in my data base, containing a fields with some names, separated by a <code>;</code> .</p>
  
  <p>I am trying to get, with a Select query, as many lines, that there is name in my field.</p>
  
  <p>So, if I got in my DB :</p>
  
  <pre><code>id names
  1  john;jack;mike
  </code></pre>
  
  <p>With this, i must get with this query : </p>
  
  <pre><code>SELECT id, split(names, ';') from table 
  
  1 john
  1 jack
  1 mike
  </code></pre>
  
  <p>I don't have any other table, so no join.</p>
  
  <p>I write :  split(names, ';'), but this is just an example of what I want to do.</p>
  
  <p>But I don't know how to split my field names to do it like ahead.</p>
  
  <p>I don't found any thing to help me, find a way to do it.</p>
  
  <p>Do I need to use a function? Is there a function to do so with oracle?</p>
  
  <p>Thank you.</p>