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!

Regular expression - to update partial string in a column value

1056154Nov 21 2013 — edited Dec 17 2013

Hi,

Any one help me get solution for my problem. Its:

In a table i have data in a column with delimiter | (pipe symbol). I need to update particular string data in this. For example i have data like below:

zebra | Hippo | tiger

I would like to change the value tiger to xyz such that first row should not get affected. all the other three rows should be updated and it can look like below:

zebra | Hippo | XYZ

what is the best thing that can be done?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 14 2014

Added on Nov 21 2013

8 comments

1,035 views