Oracle 查询字符出现次数

 

 

SELECT LENGTH(REGEXP_REPLACE(REPLACE('1234565', '5', '@'),  '[^@]+',  '')) COUNT FROM DUAL;


SELECT LENGTHB(TRANSLATE('ABCDEFGEFGDBE','E'||'ABCDEFGEFGDBE','E')) FROM DUAL;

SELECT LENGTHB('ABCDEFGEFGDBE')-LENGTHB(REPLACE('ABCDEFGEFGDBE','E','')) FROM DUAL;