title: Remove newlines in oracle sql
body: <p>Currently in address column in test table,i have data in following format,</p>
  
  <blockquote>
    <p>12th street</p>
    
    <p>Test avenue</p>
    
    <p>Test_City</p>
  </blockquote>
  
  <p>but in the output,i would require it in following format,</p>
  
  <blockquote>
    <p>12th street Test avenue Test_City.</p>
  </blockquote>
  
  <p>Could any one please tell me the query to use to display it in the required manner.</p>