title: New Line while inserting into VARCHAR2 column
body: <blockquote>
    <p>I have a requirement where i need  to prepare data for email ,So i   populate<br>
    data into  column of table having VARCHAR2(4000) as definition, Now what i want, is to 
    insert it into new line wherever i want to .</p>
  </blockquote>
  
  <pre><code> begin
   v_email := v_email ||--new line--??;
   end;
  </code></pre>
  
  <p>Suppose i am preparing email text 'List of all blocked transaction id ' ..in one line
  1)transaction_id  ....in another lin e
  2)transaction_id .....in another line.</p>
  
  <blockquote>
    <blockquote>
      <p>I am using oracle as rdbms .</p>
    </blockquote>
  </blockquote>