Path: text.usenetserver.com!out03a.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!news.mixmin.net!proxad.net!feeder1-2.proxad.net!cleanfeed2-a.proxad.net!nnrp19-2.free.fr!not-for-mail
From: "Michel Cadot" <micadot{at}altern{dot}org>
Newsgroups: comp.databases.oracle.misc
References: <1186444143.213413.19310@57g2000hsv.googlegroups.com> <46b7ecf1$0$30780$426a74cc@news.free.fr> <1Jpui.21366$j7.383804@news.indigo.ie>
Subject: Re: vowels in oracle
Date: Wed, 8 Aug 2007 22:36:34 +0200
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
Lines: 47
Message-ID: <46ba2953$0$31221$426a74cc@news.free.fr>
Organization: Guest of ProXad - France
NNTP-Posting-Date: 08 Aug 2007 22:36:35 MEST
NNTP-Posting-Host: 82.67.171.166
X-Trace: 1186605395 news-2.free.fr 31221 82.67.171.166:4653
X-Complaints-To: abuse@proxad.net
Xref: usenetserver.com comp.databases.oracle.misc:249168
X-Received-Date: Wed, 08 Aug 2007 16:36:35 EDT (text.usenetserver.com)


"Paul Linehan" <plinehan__A@T__yahoo__D.OT__COM> a écrit dans le message de news: 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"?

'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