title: Formatting carriage return, line feed in Oracle PL/SQL
body: <p>I have problems regarding a mail body formatting I'm sending:</p>
  
  <p>Here is the KO version (no new lines):</p>
  
  <pre><code>declare
    crlf                     VARCHAR2(2) := chr(13)||chr(10); 
    msg_body                 VARCHAR2(2000);
  begin
    msg_body := msg_body || ('Blablah  : '|| SYSTIMESTAMP ) || crlf;
    msg_body := msg_body || ('Blablah  : '|| SYSTIMESTAMP ) || crlf;
    EXECUTE IMMEDIATE 'ALTER SESSION SET smtp_out_server = ''127.0.0.1''';
    UTL_MAIL.send(sender =&gt; 'xx@xx.com', recipients =&gt; 'yy@yy.com', subject =&gt; 'Blah', MESSAGE =&gt; msg_body);
  end;
  </code></pre>
  
  <p>Here is the OK version (nice new lines):</p>
  
  <pre><code>declare
    crlf                     VARCHAR2(2) := chr(13)||chr(10);
    msg_body                 VARCHAR2(2000);
  begin
    msg_body := msg_body || ('Blablah  : ') || crlf;
    msg_body := msg_body || ('Blablah  : ') || crlf;
    EXECUTE IMMEDIATE 'ALTER SESSION SET smtp_out_server = ''127.0.0.1''';
    UTL_MAIL.send(sender =&gt; 'xx@xx.com', recipients =&gt; 'yy@yy.com', subject =&gt; 'Blah', MESSAGE =&gt; msg_body);
  end;
  </code></pre>
  
  <p>Best regards</p>