title: Escaping New Line character within SQL query
body: <p>I am reading a table using my java code and creating a csv file out of it. So the 4 rows that I have get converted similar to below -</p>
  
  <pre><code>sam , 18 , banker , He likes to play football 
  jam , 28 , hacker , he likes nothing
  </code></pre>
  
  <p>However in certain cases when the last varchar2 column contains \n it becomes like this </p>
  
  <pre><code>sam , 18 , banker , He likes 
                      to play
                      football 
  jam , 28 , hacker , he 
                      likes
                      nothing
  </code></pre>
  
  <p>When I try to read the file , each line is read one at a time and I'm not able parse the data due to few words being pushed to subsequent lines. Is there a way to escape the new line character within the column in my query to make it into a single line?</p>
  
  <p>My sql query  </p>
  
  <pre><code>select name , age , job , hobbies from person_details
  </code></pre>
  
  <p>I am using csvwriter to generate the csv file -</p>
  
  <pre><code>CSVWriter csvWriter = new CSVWriter(new FileWriter(results), DELIMITER, Character.MIN_VALUE, CSVWriter.NO_QUOTE_CHARACTER, CSVWriter.DEFAULT_LINE_END);
  </code></pre>
  
  <p>I used the below to remove line breaks. However looking for ways to preserve them as well -</p>
  
  <p><code>replace (replace (hobbies, chr (13), ''), chr (10), ' ')</code></p>