title: using Substr and instr in SQL
body: <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>