Skip to Main Content

SQL & PL/SQL

Announcement

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!

Replace the string with regexp_replace

858328Mar 22 2018 — edited Mar 22 2018

Hello,

Could you please advise how to replace the string after COMPLIANCE by using regexp_replace.

I want to replace the CO with MP in the string but search position start after COMPANY.

Str :  COMPANY|CO||||||||||

Output: COMPANY|MP||||||||||

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 19 2018
Added on Mar 22 2018
6 comments
131 views