I'm trying to find a list of words with 2 or more vowels. The word can be mixed case.
This is as close as I have gotten but its incorrect. Can someone please help me out.
with data as (
select 'outLOOK' as word from dual union all
select 'today' as word from dual union all
select 'help' as word from dual
)
select * from data
where regexp_like( word, '[aeiou]{2}' )
and LENGTH(word) > 5;