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 -> Re: vowels in oracle

Re: vowels in oracle

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 8 Aug 2007 22:36:34 +0200
Message-ID: <46ba2953$0$31221$426a74cc@news.free.fr>

"Paul Linehan" <plinehan__A_at_T__yahoo__D.OT__COM> a écrit dans le message de news: 1Jpui.21366$j7.383804_at_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"?

'x' is not a vowel, it is kept in the translate.
'y' is a vowel in French, fix it if this is not the case in your language
'u' is present in the list


|
| 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?

Maybe you should learn SQL before posting wrong answer.

|
|
| Paul...
|
|

Regards
Michel Cadot Received on Wed Aug 08 2007 - 15:36:34 CDT

Original text of this message

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