Re: Number of particular characters in a given string?

what's wrong with

select length('CORPORATE FLOOR') - length(replace('CORPORATE FLOOR','O')) from dual
/

which dutifully yields a value of 4 ??

Raj

On Fri, 18 Feb 2005 13:54:19 -0500, Sami Seerangan <dba.orcl_at_gmail.com> wrote:
> Is there any Oracle pre-defined fucntion to calculate number of given
> characters IN a given string?
>
> For example, I want to know how many "O"s in string 'CORPORATE FLOOR'.
>
> Thanks
> Sami
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';
--
http://www.freelists.org/webpage/oracle-l