统计特殊字符个数 1、regexp_count2、translate 1、regexp_count sql select regexp_count(d1,','),level from (select 'a,b,c,d,e,f' d1 from dual) connect by level<regexp_count(d1,',')+1 2、translate sql select length(translate(d1,','||d1,',')),level from (select 'a,b,c,d,e,f' d1 from dual) connect by level<regexp_count(d1,',')+1