title: How to get a substring after first and second white space in Oracle
body: <p>I have a problem in oracle ,i.e  I have  a policy number as <code>'  125896547        0101'</code>, I need  a substring as <code>'125896547'</code>.The first space and the second space after the digits should be removed. I am using the query as</p>
  
  <pre><code> substr(RC_POLICY_NO,1,instr(RC_POLICY_NO,'')) 
  </code></pre>
  
  <p>which is  not working , please suggest.</p>