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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

search for lowercase characters in a column

Finbar FitzgeraldSep 7 2009 — edited Sep 7 2009

Hi all,

I have a database Oracle 9.2. There is a table called CUST with 35 million rows. In this table there is a column SURNAME defined as VARCHAR2 and length 50.

My question is this: Most of the surnames have been saved in all uppercase however a small number of them are in a mix of uppercase and lowercase. I am looking for a SQL query that will return all rows where this column contains lowercase characters. Can anyone help with a simpe query that can do this ?

Many thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 5 2009

Added on Sep 7 2009

12 comments

11,431 views