Skip to Main Content
Forums

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 string that occurs right after nth occurence of a pattern

User_JSL24Jun 4 2020 — edited Jun 4 2020

Hi All,

Hope you are all doing good and staying safe !!

I am storing a number which has dots. I need to find the nth occurence of a pattern i.e dots and replace the string that occurs right after nth occurence.

For instance, in the below example I want to find the 2nd occurence of dot and replace string '0000' with '5678'

Actual -- 500.213.0000

Expected -- 500.213.5678

Can someone please help me.

Thank you.
This post has been answered by Solomon Yakobson on Jun 4 2020
Jump to Answer
Comments
Post Details
Added on Jun 4 2020
14 comments
3,485 views