Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Fri Feb 18 2005 - 16:32:19 CST
![]() |
![]() |