For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
select regexp_replace('1/5AN4/4145','/','',1,1) from dual;
Output : '15AN 4/41 45'
I have to replace regexp_repalce with SUBSTR