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: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Thu, 09 Aug 2007 14:29:12 GMT
Message-ID: <YwFui.98686$xk5.93982@edtnps82>


So how do you deal with the Dutch 'ij' combination, somewhat similar to the 'y'.

-- 
Terry Dykstra
"Michel Cadot" <micadot{at}altern{dot}org> wrote in message 
news:46ba2953$0$31221$426a74cc_at_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 Thu Aug 09 2007 - 09:29:12 CDT

Original text of this message

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