[Oracle] Oracle Translate 统计字符出现的次数示例代码

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

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

TRANSLATE(string,from_str,to_str)

SELECT TRANSLATE('abcdefghij','abcdef','123456') FROM dual;
123456ghij
SELECT TRANSLATE('abcdefghij','abcdefghij','123456') FROM dual;
123456

select translate('abcbbaadef','ba','#@') from dual（b将被＃替代，a将被＠替代）
select translate('abcbbaadef','bad','#@') from dual（b将被＃替代，a将被＠替代，d对应的值是空值，将被移走）

SELECT TRANSLATE('2KRW229','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ','9999999999XXXXXXXXXXXXXXXXXXXXXXXXXX')      "License"FROM DUAL

SELECT TRANSLATE('2KRW229','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ','0123456789') "Translate example"FROM DUAL

SELECT TRANSLATE('我是中国人,我爱中国', '中国', 'China') "Translate example" FROM DUAL

SELECT TRANSLATE('I am Chinese, I love China', 'China', '中国') "Translate example" FROM DUAL

SELECT TRANSLATE('2KRW229','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ','') "License" FROM DUAL

SELECT TRANSLATE('中国人', substr('中国人',1,length('中国人') - 1), rpad('*',length('中国人'),'*')) "License" FROM DUAL