using Substr and instr in SQL
<p>I am trying to extract the middle of the string from record. I want to get the only middle of the string.</p>

<pre><code>select instr('WUK00000105376:<b>WUKE03960761</b>:WUKR0093868603',':') 
from dual;</code></pre>

<p>I want to get only <code>WUKE03960761</code> from this string.</p>

<p>I have tried by using sustring and instring to get the output but i am not getting.</p>