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 only the last 3 characters inside a string

Roger25Oct 18 2011 — edited Oct 18 2011
Hi all,
I have the string "abcdef_01". How can i replace the last 3 characters with '000'? for example in that string, '_01' should be replaced with '000'. Is any way to do this, without concatenating the original string with the last 3 characters replaced with '000'?
Thanks

Edited by: Roger22 on 18.10.2011 09:29
This post has been answered by RogerT on Oct 18 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 15 2011
Added on Oct 18 2011
12 comments
8,078 views