Oracle Identifying multiple spaces using REGEXP_LIKE

Question

I'm trying to identify fields that have more than one space in a comment, e.g. 'this lhas three spaces'

Using this I can get anything with two spaces, but would like to be able to get 2 or more:

select * from labtec.spaces
where REGEXP_LIKE(SPACES, '[[:space:]]{2}');

Any suggestions?

Answer 1

I believe that you can:

select * from labtec.spaces
where REGEXP_LIKE(SPACES, '[[:space:]]{2,}');

Note the comma.

For "Between three and five" you would use {3,5}, for "two or more" {2,}, for "eight or less" {,8}