CODEWITHSUNDEEP
sqlregexoracle-database
padibro
padibro

Reputation: 1374

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

but the result is equal to

select * from  MYTABLE t

Upvotes: 0

Views: 1053

Answers (1)

Aleksej
Aleksej

Reputation: 22969

You may need to explicily force a case sensitive comparison:

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

From Oracle documentation:

If you omit match_parameter, then:

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

Upvotes: 2

Related Questions