By rad_jen
SQL> select substr('xyxxyyxxxyyyxy',-12,12) from dual;
If you really want to use hard code value then why not simply
substr('xyxxyyxxxyyyxy', 3) or is there any specific reason.