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 only first occurence in the string

Vishal R.Oct 21 2009 — edited Oct 21 2009

Hi

Do we have function in sql where in only the first occurence in the string is replace with the desired string.

Example:

original string: 'Oracle is the best. Oracle is great'

Now, i need to change only the first occurrence of oracle

modified string:'Replaced is the best. Oracle is great'

do we have any function to do this?

This post has been answered by 21205 on Oct 21 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 18 2009

Added on Oct 21 2009

13 comments

3,096 views