比如这个字串'1111111111,1111111232,2222222565,',怎样判断这个字串里的“,”号的个数,有什么函数没有
---------------------------------------------------------------
SQL> select lengthb('ad,wef,wert,erg')-lengthb(replace('ad,wef,wert,erg',',','')) from dual;
LENGTHB('AD,WEF,WERT,ERG')-LENGTHB(REPLACE('AD,WEF,WERT,ERG',',',''))
---------------------------------------------------------------------
3
已用时间: 00: 00: 00.20
SQL>