Number of particular characters in a given string?

  • From: Sami Seerangan <dba.orcl@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 18 Feb 2005 13:54:19 -0500

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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2005