Re: character count in a string

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 23 Jan 2007 09:28:04 -0800
Message-ID: <1169573280.589094@bubbleator.drizzle.com>

Charles Hooper wrote:
> Eitan M wrote:

>> Hello,
>> how can I get a specific character count in a string
>> (
>> i.e : string is 56222, and I am looking for '2' occurance
>> when i do :
>> select charcount('56222') should return : 3
>> )
>>
>> Thanks :)

>
> INSTR is all that you need. See:
> http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/functions068.htm
>
> Charles Hooper
> PC Support Specialist
> K&M Machine-Fabricating, Inc.

Given the quality of your responses I am going to have to ask ... how. I think Anurag's response is one solution and this would be mine.

SELECT LENGTH(TRANSLATE('56222', '2013456789', '2')) FROM dual;

Though I can see numerous creative possibilities using regular expressions, etc.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Tue Jan 23 2007 - 11:28:04 CST