title: Regexp_replace processing result
body: <p>I have a string with groups of nubmers. And Id like to make constant length string. Now I use two regexp_replace. First to add 10 numbers to string and next to cut string and take last 10 values:</p>
  
  <pre><code>with s(txt) as ( select '1030123:12031:1341' from dual)
  select regexp_replace(
         regexp_replace(txt, '(\d+)','0000000000\1')
  ,'\d+(\d{10})','\1') from s ;
  </code></pre>
  
  <p>But Id like to use only one regex something like </p>
  
  <pre><code>regexp_replace(txt, '(\d+)',lpad('\1',10,'0'))
  </code></pre>
  
  <p>But it don't work. lpad executed before regexp. Could you have any ideas?</p>