SELECT LENGTHB(TRANSLATE('1,2,34,5',',12345',',')) FROM DUAL; SELECT LENGTHB('1,2,34,5')-LENGTHB(REPLACE('1,2,34,5',',','')) FROM DUAL;