title: SQL - Splitting a single column into multiple rows
body: <p>I have a record that looks like this in the database  (As an example).</p>
  
  <pre><code>ID, Name, Brand
  1, 'Bike', 'Schwinn'
  2, 'Car', 'Ford, Honda, Chevy'
  3, 'Bike', 'Schwinn, Trex'
  4, 'Car', 'Honda'
  </code></pre>
  
  <p>I need to export the data out and create multiple records where Brand has multiple entries. I also need to increase the ID on output so I don't have duplicates. (I can use a sequence for this and would set it higher to my max value in db).</p>
  
  <p>My output would look like</p>
  
  <pre><code>ID, Name, Brand
  1, Bike, Schwinn
  2, Car, Ford
  Sequence.nextval, Car, Honda
  Sequence.nextval, Car, Chevy
  3, Bike, Schwinn
  Sequence.nextval, Bike, Trex
  4, Car, Honda
  </code></pre>
  
  <p>I would like to try and to this with a <code>SQL</code> statement.  Basically I'm dumping this data as a <code>csv</code> file via straight <code>SQL</code>.</p>
  
  <p>My difficulty is trying to <code>loop/split</code> through the Brand column.</p>