title: Split column which have two or three word by space in oracle sql
body: <p>I have a legacy column in my table which stores name and surname values together. 
  For Example:  <code>Mike Huge Muyra</code> or <code>John Kutgira</code>. </p>
  
  <p>I need to split column by whitespace. </p>
  
  <p>Result must be like that (<strong>Last word is surname, others are name</strong>)</p>
  
  <pre><code>Name : Mike Huge,  Surname : Muyra
  Name : John,       Surname : Kutgira
  </code></pre>
  
  <p>I have been researching for two hours. (<strong>REGEXP_SUBSTR</strong> is looking cool) But I can not find the solution.</p>