Re: SQL to get total count for each colon delimited entry
From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Sat, 23 Jan 2010 01:31:11 -0800 (PST)
Message-ID: <a433c18c-063f-4b77-8367-07af78189bd4_at_21g2000yqj.googlegroups.com>
On Jan 21, 11:43 pm, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> cbarak wrote:
> > On Jan 21, 2:42 pm, "Michel Cadot"<micadot{at}altern{dot}org> wrote:
> >> SQL> select length('rc:jh:nb')-length(replace('rc:jh:nb',':',''))+1 nb from dual;
> >> NB
> >> ----------
> >> 3
>
> >> 1 row selected.
>
> >> Regards
> >> Michel
>
> > Thanks Michel!
>
> Cette solution vous est apportée par Michel Cadeau.
Date: Sat, 23 Jan 2010 01:31:11 -0800 (PST)
Message-ID: <a433c18c-063f-4b77-8367-07af78189bd4_at_21g2000yqj.googlegroups.com>
On Jan 21, 11:43 pm, "Gerard H. Pille" <g..._at_skynet.be> wrote:
> cbarak wrote:
> > On Jan 21, 2:42 pm, "Michel Cadot"<micadot{at}altern{dot}org> wrote:
> >> SQL> select length('rc:jh:nb')-length(replace('rc:jh:nb',':',''))+1 nb from dual;
> >> NB
> >> ----------
> >> 3
>
> >> 1 row selected.
>
> >> Regards
> >> Michel
>
> > Thanks Michel!
>
> Cette solution vous est apportée par Michel Cadeau.
Was this a french wordplay? Or are you just giving credit where credit is due?
Regards,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Sat Jan 23 2010 - 03:31:11 CST