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!

How to replace first occurrence of a substring

699031May 6 2009 — edited Jul 1 2011
How to replace first occurrence of a substring from my original string? any built in functions available in PL/SL?
EX: Original string: "webinweb" i need the output string as: "xyzinweb" just replace first occuarnce of "web" by "xyz"
This post has been answered by MichaelS on May 6 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 29 2011
Added on May 6 2009
5 comments
26,736 views