padibro padibro - 2 years ago 76
SQL Question

How to use regular expression in Oracle SQL query

I have a table with a column 'DESCRIPTION'.
I would like retrieve, by a regular expression, only rows with at least one lower case character.

I have tried

select * from MYTABLE t

but the result is equal to

select * from MYTABLE t

Answer Source

You may need to explicily force a case sensitive comparison:

select *
from  MYTABLE t 

From Oracle documentation:

If you omit match_parameter, then:

The default case sensitivity is determined by the value of the NLS_SORT parameter

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download