title: Replacing last occurrence of character group with Oracle REGEXP_REPLACE
body: <p>I have strings like the following in my Oracle 11g table:</p>
  
  <pre><code>ABCDEF000xyz12345abcdefgh
  
  GHIJK0000def67890abcdefgh
  </code></pre>
  
  <p>I.e., the strings begin with capital letters followed by a series of zeros, followed by three characters, digits and characters again.</p>
  
  <p>How can I replace the <code>xyz12345abcdefgh</code> and <code>def67890abcdefgh</code> with a certain string using REGEXP_REPLACE in Oracle?</p>