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 do I identify all upper case words and change to initcaps?

PhilMan2Mar 8 2015 — edited Mar 11 2015

Hello,

I'm using Oracle 11.g

I have a table with several varchar2 columns of text data.  There are several words that are all upper case.  In every instance, those upper case words should be changed to mixed case (e.g. HELLO to Hello).  How do I find upper case words in all rows and change them to mixed case?

Thanks for your help.
This post has been answered by Etbin on Mar 11 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2015
Added on Mar 8 2015
14 comments
6,825 views