统计字符串a,b,c,d,e,f中‘,’的个数
select lengthb(regexp_replace('[a,b,c,d,e,f]','[^,]',null)) as res from dual;
select * from SYS_DEPT where lengthb(regexp_replace(dept_id,'[^A]',null))=3;