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!

Replacing Character by position

B RApr 30 2009 — edited Sep 3 2012
Hi All,

I am not sure if any body came across this scenario.But I have requirement like follows.

I need to replace a particular charater (position wise) with another charater.

Lets take example: string="world"

I need to replace character no.4 with say "S".

so the final string would be "worsd".

Is there any inbuild function given by oracle for performing this?

I am using Oracle 10g.

Your comments are important.

Regards,
Tarak
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2012
Added on Apr 30 2009
10 comments
23,454 views