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: Counting the number of occurrences of a specific character is a column

Re: Counting the number of occurrences of a specific character is a column

From: Randy Harris <randy_at_SpamFree.com>
Date: Thu, 08 Dec 2005 02:35:52 GMT
Message-ID: <c_Mlf.24543$BZ5.7452@newssvr13.news.prodigy.com>

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:43975085$0$5767$626a14ce_at_news.free.fr...
>
> select length(translate(Appt.Availtime,'0125','0'))*5/60 "NormalAppt",
> length(translate(Appt.Availtime,'1250','1'))*5/60 "CancelAppt",
> length(translate(Appt.Availtime,'2501','2'))*5/60 "MovedAppt",
> length(translate(Appt.Availtime,'5012','5'))*5/60 "NoShow"
> from Appt ...

Pure Wizardry! Received on Wed Dec 07 2005 - 20:35:52 CST

This message: [ Message body ]
Next message: Galen Boyer: "Re: Can you pass a table name into a stored procedure?"
Previous message: Gerard Lacroix: "Cursor concept"
In reply to: Michel Cadot: "Re: Counting the number of occurrences of a specific character is a column"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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