Skip to Main Content
Forums

Need help on substr fucntion

User_X9S6MDec 15 2022

select regexp_replace('1/5AN4/4145','/','',1,1) from dual;

Output : '15AN 4/41 45'

I have to replace regexp_repalce with SUBSTR
This post has been answered by mathguy on Dec 15 2022
Jump to Answer
Comments
Post Details
Added on Dec 15 2022
#sql, #sqldeveloper, #sqlplus
2 comments
40 views