title: Oracle SQL -- remove partial duplicate from string
body: <p>I have a table with a column with strings that looke like this:</p>
  
  <pre><code>static-text-here/1abcdefg1abcdefgpxq
  </code></pre>
  
  <p>From this string <code>1abcdefg</code> is repeated twice, so I want to remove that partial string, and return:</p>
  
  <pre><code>static-text-here/1abcdefgpxq
  </code></pre>
  
  <p>I can make no guarantees about the length of the repeat string. In pure SQL, how can this operation be performed?</p>