title: What is the newline character in Oracle
body: <p>Running in sqldeveloper, this prompts an empty cell in the results</p>
  
  <pre><code>select regexp_replace(chr(10) || chr(13), '\n', 'New Line')
  from dual
  </code></pre>
  
  <p>I was expecting this to be <code>'_New Line'</code> or <code>'New Line_'</code> but instead I get <code>'__'</code> (Note that underscore is visually an empty space).</p>
  
  <p>This doesn't work either.</p>
  
  <pre><code>select regexp_replace(
    UNISTR('\000A') 
    || UNISTR('\000D')
    , '\n', 'New Line')
  from dual
  </code></pre>
  
  <p>Specifically I need this to work in java. There is a method that will invoque a stored procedure that returns a cursor with columns that may have line breakings. From the java side I need this to work:</p>
  
  <pre><code>String or = resultset.getString("some_column"); // null check left for simplicity    
  ... = or.split("\\n"); 
  ... = or.split("\\r?\\n"); 
  </code></pre>
  
  <p>I was testing with regexp_replace because it is supposed to do the same.</p>