1.
select length('ab,c,d,efg')-length(replace('ab,c,d,efg',',',''))from dual;
2.
select lengthb(regexp_replace('ab,c,d,efg','[^,]',null)) from dual;
1.
select length('ab,c,d,efg')-length(replace('ab,c,d,efg',',',''))from dual;
2.
select lengthb(regexp_replace('ab,c,d,efg','[^,]',null)) from dual;