I want to know how many times comma(,) appear in string ...

I want to know the count of the string or character

as follows .

Given,
ls_string = '1253,5678,ascd,!@#er, 5896, @@@;';

How many times appear comma(,) in the string 'ls_string' ?

   The result : The comma(,) appears five times in the 'ls_string' .

Is there any function or other way to resolve this problem ?

We use Oracle 7.3.3.3.

Thanks in Advance . Received on Mon Sep 27 1999 - 03:02:33 CDT