title: Split varchar into separate columns in Oracle
body: <p>I'm in a bit of a pickle:  I've been asked to take in comments starting with a specific string from a database, and separate the result into separate columns.</p>
  
  <p>For example -- if a returned value is this:</p>
  
  <pre><code>COLUMN_ONE
  --------------------
  'D7ERROR username'
  </code></pre>
  
  <p>The return needs to be:</p>
  
  <pre><code>COL_ONE    COL_TWO
  --------------------
  D7ERROR   username   
  </code></pre>
  
  <p>Is it even possible to define columns once the result set has been structured just for the sake of splitting a string into two?</p>