title: Select query result in single row comma separated format
body: <p>I have a table and values as following example and when i select, i need the result to be available in single row with comma separated.</p>
  
  <p>Table1.new_field
  value1
  value2
  value3</p>
  
  <p>I need the result as following for the select query.</p>
  
  <p>value1, value2, value3...</p>
  
  <p>I checked functions like wm_concat but no luck. I am using oracle 10g. Please suggest how to achieve this. </p>
  
  <p>TIA.</p>