title: Oracle split text into multiple rows
body: <p>Inside a varchar2 column I have text values like :</p>
  
  <pre><code>aaaaaa. fgdfg.
  bbbbbbbbbbbbbb ccccccccc
  dddddd ddd dddddddddddd,
  asdasdasdll
  sssss
  </code></pre>
  
  <p>if i do <em>select column from table where id=...</em> i get the whole text in a single row, normally.
  But i would like to get the result in multiple rows, 5 for the example above.
  I have to use just one select statement, and the delimiters will be new line or carriage return (chr(10), chr(13) in oracle)</p>
  
  <p>Thank you!</p>