Hi Expert,
I'm trying to get number of dots in a particular string .below is my sql query where it is returning me count as 11
select regexp_count('23.78.86.87','.') from dual;
O/p -11
However if i use the below query to count comma it's giving me correct output
select regexp_count('23,78,86,87',',') from dual;
o/p-3
Appreciate your support.
Thanks,
Pritam