Re: vowels in oracle

From: Paul Linehan <plinehan__A_at_T__yahoo__D.OT__COM>
Date: Wed, 08 Aug 2007 20:29:49 GMT
Message-ID: <1Jpui.21366$j7.383804@news.indigo.ie>

Michel Cadot wrote:

> SQL> with data as (select 'Whose line is it anyway' line from dual)
> 2 select length(line)-length(translate(line,'xaeiouy','x'))
> nbVowels 3 from data
> 4 /

"x" and "y" are now vowels?
What about "u"?

> select 'Whose line is it anyway'
> count('o', 'e', 'i', 'a', 'y')
> from dual;

Maybe we should check out OP's language first and then tell him how to get the vowels?

Paul... Received on Wed Aug 08 2007 - 15:29:49 CDT