Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Finding words with 2 or more vowels

PugzlyMar 22 2022 — edited Mar 22 2022

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;
This post has been answered by Frank Kulash on Mar 22 2022
Jump to Answer
Comments
Post Details
Added on Mar 22 2022
4 comments
725 views