title: Can we display chr(10) (newline) in the Query Result Window? (SQL Developer)
body: <p>SQL Developer question (SQL Developer is the free IDE from Oracle - do not confuse with PL/SQL Developer, a different product):</p>
  
  <p>The Query Result Window (where query results are shown) does not display newlines (<code>chr(10)</code>) embedded in text strings. That is, it will display the text <code>'one' || chr(10) || 'two'</code>, which should be displayed in a single table row but two lines of text, as <code>onetwo</code>. If one right-clicks the cell in the query result window and selects "Single Record View", the text is displayed correctly in two lines. </p>
  
  <p>I checked Tools - Preferences - Database - Worksheet and I didn't see a setting for this behavior. Is there, in fact, a way to change it?</p>
  
  <p>To illustrate the issue - consider this query run in SQL*Plus:</p>
  
  <pre><code>SQL&gt; select 'one' || chr(10) || 'two' as text_string from dual;
  
  TEXT_ST
  -------
  one
  two
  
  1 row selected.
  </code></pre>
  
  <p>Notice the result is just one row (<code>1 row selected</code>) but the text is in two lines of text (still in a single row in the result set).</p>
  
  <p>The same query in SQL Developer produces:</p>
  
  <p><a href="https://i.stack.imgur.com/71gr5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/71gr5.png" alt="SQL Developer screenshot"></a></p>
  
  <p>Also: I am aware that I can get the "right" result (in two lines) if I run the statement as a script (F5 or Run Script button, instead of CTRL-ENTER or Run Statement button). I am not asking for a workaround; I am asking the question literally, is it possible to change the Query Result Window behavior.</p>