Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> vowels in oracle

vowels in oracle

From: wajim <wajim29_at_hotmail.com>
Date: Mon, 06 Aug 2007 16:49:03 -0700
Message-ID: <1186444143.213413.19310@57g2000hsv.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US