pl sql dbms_lob.substr or regex_substr get text between new lines
<p>I got a table with a clob field that contains the next string:</p>

<pre><code>"hello world Chr(13)
hello world 2 chr(13)
hello world 3"
</code></pre>

<p>I m trying to get the text "<code>hello world 2</code>" between the first and the last break line but I still cannot.</p>

<p>I try it with <code>DBMS_LOB.INSTR</code> and <code>regexp_substr</code> without success... anybody can help me here?</p>

<p>Thanks a lot.</p>