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!

Need to convert part of a string from lowercase to uppercase

255654Jun 30 2006 — edited Jul 9 2006
Hello,

I need to update/convert parts of a string from lowercase to uppercase. See example in the following table:

id string date_created
1 100000_AAA_20060630_EN.pdf 30-06-2006
2 100000_AAA_20060630_en.pdf 30-06-2006
3 100000_AAA_20060630_en.PDF 30-06-2006

All these strings must be converted to 100000_AAA_20060630_EN.pdf

I really need to know how to accomplish this. I was not able to write a normal update for this.

Can anyone help me out with this?


Regards,
Ronny.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2006
Added on Jun 30 2006
20 comments
6,247 views