Re: SQL to get total count for each colon delimited entry
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Thu, 21 Jan 2010 21:43:48 +0100
Message-ID: <4b58bc82$0$2884$ba620e4c_at_news.skynet.be>
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!
Date: Thu, 21 Jan 2010 21:43:48 +0100
Message-ID: <4b58bc82$0$2884$ba620e4c_at_news.skynet.be>
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. Received on Thu Jan 21 2010 - 14:43:48 CST