vowels in oracle

Hi everyone,
Can somebody give help with a sql statement that retrieves the count of vowels in a semtence...

Write a select statement that returns the number of vowels in the sentence

        'Whose line is it anyway'

I have tried something like

select 'Whose line is it anyway'

          count('o', 'e', 'i', 'a', 'y')
        from dual;

it's not working.

Thanks in advance. Received on Mon Aug 06 2007 - 18:49:03 CDT