RE: Number of particular characters in a given string?
- From: "Rudy Zung" <Rudy.Zung@xxxxxxx>
- To: <dba.orcl@xxxxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 18 Feb 2005 15:59:23 -0500
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@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
