Hi all,
I have a database Oracle 11G. There is a table called TEMP with 35 million rows. In this table there is a column DESCRIPTION defined as VARCHAR2 and length 50.
My question is this: Most of the DESCRIPTION have been saved in all uppercase however a small number of them are in a mix of uppercase, lowercase and symbols. I am looking for a SQL query that will return all rows where this column contains lowercase characters.
i have tried with the below one and getting results,
select description from temp where REGEXP_LIKE(description, '[[:lower:];
FINISH 2x25
FINISH 2&2!5
FINISH 23 SiV
Finish........ex
but I am looking for a SQL query that will return all rows where this column contains 100% lowercase characters.
Ex:
FINISH 23 SiV
Finish
could anyone help on this?
Thanks.