title: Oracle sql - concatenate all columns
body: <p>Am having a table with 30+ columns. Would like to append all the column data.</p>
  
  <p>I'm currently using multiple concatenate operators to achieve this in Oracle.</p>
  
  <p>Example :
  <code>SELECT C1.data || '' || C2.data ||..........Cm.data
  FROM C</code></p>
  
  <p>Is there any other way of doing it with out using the '||' - concatenate operator multiple times ? I want to achieve this using query. (Not interested in post processing using any language) Any assistance would be of great help. </p>