title: how to split words in oracle
body: <p>Problem: text is shown without line break or chr(10);</p>
  
  <p>suppose test</p>
  
  <p>column_name (text)</p>
  
  <pre><code>       hello world hello world hello world hello world.
         hello world.
  </code></pre>
  
  <p>sql i tried</p>
  
  <pre><code>select REPLACE(REPLACE( text, CHR(10) ), CHR(13) )  
  from dual
  </code></pre>
  
  <p>but it still give output in single line.</p>
  
  <pre><code>hello world hello world hello world hello world.hello world.
  </code></pre>
  
  <p>any solution is most welcome.</p>
  
  <p>Solution that worked</p>
  
  <pre><code>select REPLACE(REPLACE(textn,chr(10) , '&lt;br&gt;'),chr(13),'') 
    INTO v_text 
  from dual;
  </code></pre>