RE: Number of particular characters in a given string?

I don't think Oracle has a built-in function for that, but you can = cobble one
together with:

   length(myString) - nvl(length(replace(myString, 'O')), 0)

...Rudy

-----Original Message-----

From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sami Seerangan
Sent: Friday, February 18, 2005 1:54 PM
To: oracle-l
Subject: Number of particular characters in a given string?

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
--

http://www.freelists.org/webpage/oracle-l Received on Fri Feb 18 2005 - 16:26:38 CST