Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: vowels in oracle
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"?
OP
> 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