title: Deriving value from a string in oracle
body: <p>I have a column called NARRATION in my table and it has values like as shown below.</p>
  
  <pre><code>NARRATION
  -------------------------------------
  BI DS NO 6005527182
  BI DS NO. 485019
  CI DS NO.6008364862(2000*1) 
  CI DS NO.1905180207 10*1) EDDF34592845
  CI DS NO.2105180520-(50*1) DDFF39844240
  CI DS NO.2105180653 (2000*1) DFSD39844240
  CI DS NO.1905180220/(500*3,20
  CI DS NO.2105180166*(200*1) DSFSF39844240 
  </code></pre>
  
  <p>I want to derive first word after the text <strong>DS NO.</strong> till the next space or any other special character like as shown below.
  Some times there might be space also exists after <strong>DS NO.</strong> and from the space word starts that i need to derive.</p>
  
  <pre><code>NARRATION                                 |DERIVE_NARRATION  
  ------------------------------------------|----------------
  BI DS NO 6005527182                       |6005527182
  BI DS NO. 485019                          |485019
  CI DS NO.6008364862(2000*1)               |6008364862
  CI DS NO.1905180207 10*1) EDDF34592845    |1905180207
  CI DS NO.2105180520-(50*1) DDFF39844240   |2105180520
  CI DS NO.2105180653 (2000*1) DFSD39844240 |2105180653
  CI DS NO. 1905180220/(500*3,20            |1905180220
  CI DS NO.2105180166*(200*1) DSFSF39844240 |2105180166
  </code></pre>
  
  <p>Please help me query.</p>