How to use regular expression in Oracle SQL query

Question

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 
WHERE REGEXP_LIKE (t.DESCRIPTION, '[a-z]');

but the result is equal to

select * from  MYTABLE t

Aleksej · Accepted Answer · 2016-05-04 10:07:30Z

2

You may need to explicily force a case sensitive comparison:

select *
from  MYTABLE t 
WHERE REGEXP_LIKE (t.DESCRIPTION, '[a-z]', 'c')

If you omit match_parameter, then:

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

answered May 4, 2016 at 10:07

Aleksej

23.1k6 gold badges38 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1