chop part of the string

[kris109]

SQL> select replace('xxyyxxxyyyxy', 'xxyyxxxyyyxy', 'xxyyxxxyyy') from dual;

REPLACE('X
----------
xxyyxxxyyy