title: Regex to find 9 to 11 digit integer occuring anywhere closest to a keyword
body: <p>In simple term, what I am looking for is this If there is a string, which has a keyword <code>ZTFN00</code>, then the regex shall be able to return the closest 9 to 11 digit number to the left or right side of the string.</p>
  
  <p>I want to do this in REGEXP_REPLACE function of oracle.</p>
  
  <p>Below are some of the sample strings:</p>
  
  
  
  <pre class="lang-none prettyprint-override"><code>The following error occurred in the SAP UPDATE_BP service as part of the combine: 
  
  (error:653, R11:186:Number 867278489 Already Exists for ID Type ZTFN00)
  </code></pre>
  
  <p>Expected result: <code>867278489</code></p>
  
  <pre class="lang-none prettyprint-override"><code>The following error occurred in the SAP UPDATE_BP service as part of the combine
  
  (error:653, R11:186:Number ZTFN00 identification number 123456778 already exist)
  </code></pre>
  
  <p>Expected result: <code>123456778</code></p>