title: How to use CHR (10) to start a new line using Oracle SQL
body: <p>I'm trying to use CHR (10) to start a new line in my oracle SQL view. Where should I put it and how should it be formatted? I've seen it used in example before I just can't get it to work.</p>
  
  <pre><code>    SELECT
      CUSTOMER.FIRST_NAME ||' '||
      CUSTOMER.SURNAME ||' sold their '||
      EXTRACT (YEAR FROM CAR.FIRST_REG_DATE) ||' '|| 
      CAR.MAKE ||' '||
      CAR.MODEL ||' with '||
      CAR.CURRENT_MILEAGE ||' miles for £'|| 
      CAR.PURCHASE_PRICE ||' which was then bought on '||
      CAR.SOLD_DATE ||' for £'||
      CAR.SOLD_PRICE ||' making a profit of £'||
      (CAR.SOLD_PRICE - CAR.PURCHASE_PRICE) ||' for staff member '||
      STAFF.FIRST_NAME ||' '||
      STAFF.SURNAME 
  </code></pre>