title: Carriage Return Oracle 10g SQL
body: <p>I'm trying to write a report that I will send out in Excel which concatenates two records into the same cell, displaying a carriage return between each record. I have been trying with ||chr(10) || chr(13) || but this only works if I run as a script and not when I run the query in Excel. </p>
  
  <p>Is there a better way of forcing a carriage return?</p>
  
  <p>The select statement looks like this:</p>
  
  <pre><code>select distinct
  cap.cap_stuc "Application ID"
  ,stu.stu_surn "Surname"
  ,initcap(stu.stu_fnm1) "First Name"
  ,min(decode(rn, 1, choices.cap_pref)) || ' ' || min(decode(rn, 1,choices.cap_mcrc)) || ' ' || min(decode(rn, 1, choices.crs_name)) || chr(10)||chr(13) || min(decode(rn, 2, choices.cap_pref)) || ' ' ||  min(decode(rn, 2, choices.cap_mcrc)) || ' ' ||  min(decode(rn, 2, choices.crs_name)) "App Details"
  </code></pre>
  
  <p>Thanks </p>