Skip to Main Content

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!

initcap exceptions

268940Mar 19 2007 — edited Mar 19 2007
We load data from a source system that is all uppercase. We convert the data over using initcap but do not want this to apply to all data. For example, we have a character string of 'HO AOM UNIT'. The initcap on the field produces 'Ho Aom Unit' where we would like to see 'HO AOM Unit'. I was thinking of using the replace or translate functions to handle the exceptions but not sure how to apply to multiple character strings within one character string in one pass.

Any suggestions.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2007
Added on Mar 19 2007
1 comment
340 views