If you really want to use hard code value then why not simplyBy rad_jen
SQL> select substr('xyxxyyxxxyyyxy',-12,12) from dual;
substr('xyxxyyxxxyyyxy', 3) or is there any specific reason.
|
Results 1 to 9 of 9
Thread: chop part of the stringThreaded View
|
Click Here to Expand Forum to Full Width |