title: Oracle regexp_replace every occurence
body: <p>I want to replace the every occurrence of String except for the first occurrence, using <code>regexp_replace</code>. Below query will replace only second occurrence.</p>
  
  <pre><code>select 'This is test STRING STRING some text STRING some more text'
    from dual 
  
  select regexp_replace('This is test STRING STRING some text STRING some more text',
                        'STRING',
                        'REPLACED-STRING' ,
                        1,
                        2)
    from dual
  </code></pre>
  
  <p>Results is,</p>
  
  <blockquote>
    <p>This is test STRING REPLACED-STRING some text STRING some more text</p>
  </blockquote>
  
  <p>But I need result like this.</p>
  
  <blockquote>
    <p>This is test STRING REPLACED-STRING some text REPLACED-STRING some more text</p>
  </blockquote>