title: Oracle SQL - Separate Column Into Multiple Columns
body: <p>I'm working with Oracle SQL and have a problem I don't know how to solve.
  I have a column in my table that consists of one letter (from a-f) and a number, then another letter (a-f) and another number etc.</p>
  
  <p>Example of column:</p>
  
  <pre><code>a 30, d 800, b 233
  </code></pre>
  
  <p>Is there a way where I can separate the column into multiple columns in a select statement?
  So that I get ex: </p>
  
  <pre><code>TEXTA  NUMBERA  TEXTB  NUMBERB   TEXTD   NUMBERD
    a     30       b      233       d       800
  </code></pre>