Skip to Main Content

Oracle Database Discussions

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!

Select only words with capitals

Catfive LanderJan 9 2011 — edited Jan 10 2011
If I have data stored in my Database much like this Sentence, with Some words containing uppercase letters and some not, what is the simplest Way to select only those words which contain upperCase letters?

From the above sentence, for example, I would want to see the result :
If I Database Sentence Some Way upperCase

Note that the uppercase letter(s) will not always be at the start of a word.

Is there a simple way to achieve this? I started dabbling with REGEXP_LIKE, but my regular expressions are pretty hopeless at the best of times :-(
This post has been answered by 523861 on Jan 9 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2011
Added on Jan 9 2011
18 comments
5,517 views