title: String manipulation in a column in an Oracle table
body: <p>One of my tables' column contains names, for example as <code>"Obama, Barack"</code> (with double quotes). I was wondering if we can do something to make it appear as <code>Barack Obama</code> in the tables. I think we can do it with declaring a variable but just could not manage to find a solution.</p>
  
  <p>And yes as this table contains the multiple transactions of the same person we also end up with having multiple rows of <code>"Obama, Barack"</code>... a data warehouse concept (fact tables).</p>