chop part of the string

[dba_admin]

This is the best one I can come up with.

SQL> select substr('xyxxyyxxxyyyxy',length('xy')+1) from dual;

SUBSTR('XYXXYYXXXYYYXY',LENGTH
-----------------------------------------------
xxyyxxxyyyxy

1 row selected.

Thank you for all your reply.