oracle字符串中某个字符出现次数,oracle统计某个字符在字段中出现的次数

select length(trim(translate(region_path,'a0123456789',' '))),region_path,region_level from region;

结果集：

7 0,1,2,5,75,14458,15426,15435 8

6 0,1,2,5,73,16121,16811 7

7 0,1,2,5,73,16121,16811,16812 8

7 0,1,2,5,73,16121,16811,16813 8

7 0,1,2,5,73,16121,16811,16814 8

7 0,1,2,5,73,16121,16811,16815 8

7 0,1,2,5,73,16121,16811,16816 8

7 0,1,2,5,73,16121,16811,16817 8

6 0,1,2,5,73,16121,16827 7

7 0,1,2,5,73,16121,16827,16828 8

7 0,1,2,5,73,16121,16827,16829 8

7 0,1,2,5,73,16121,16827,16830 8

6 0,1,2,5,73,16121,16843 7

7 0,1,2,5,73,16121,16843,16844 8

7 0,1,2,5,73,16121,16843,16845 8

7 0,1,2,5,73,16121,16843,16846 8

6 0,1,2,5,73,16121,16859 7

7 0,1,2,5,73,16121,16859,16860 8

7 0,1,2,5,73,16121,16859,16861 8

7 0,1,2,5,73,16121,16859,16863 8

7 0,1,2,5,73,16121,16859,16864 8

6 0,1,2,5,73,16121,16875 7

7 0,1,2,5,73,16121,16875,16876 8

7 0,1,2,5,73,16121,16875,16877 8

7 0,1,2,5,73,16121,16875,16879 8

7 0,1,2,5,73,16121,16875,16880 8

6 0,1,2,5,73,16122,16891 7

7 0,1,2,5,75,14459,15506,15508 8

7 0,1,2,5,76,8977,9709,9713 8

7 0,1,2,5,74,4048,7733,7745 8

7 0,1,2,5,74,4048,7733,7747 8

6 0,1,2,5,74,4042,7269 7

7 0,1,2,5,74,4042,7285,7286 8

7 0,1,2,5,74,4042,7285,7287 8

7 0,1,2,5,71,18268,18288,18324

7 0,1,2,5,71,18268,18289,18327

7 0,1,2,5,71,18268,18289,18329

7 0,1,2,5,71,18268,18289,18331

7 0,1,2,5,71,18268,18290,18333

7 0,1,2,5,71,18268,18290,18336 8

7 0,1,2,5,71,18268,18291,18341 8

7 0,1,2,5,71,18268,18292,18346

7 0,1,2,5,71,18268,18293,18351

7 0,1,2,5,71,18268,18293,18352

7 0,1,2,5,71,18269,18294,18296

7 0,1,2,5,76,8980,9901,9904 8

7 0,1,2,5,76,8980,9901,9905 8

6 0,1,2,5,76,8980,9917 7

7 0,1,2,5,76,8980,9917,9918 8

7 0,1,2,5,76,8980,9917,9919 8

7 0,1,2,5,76,8980,9917,9920 8

7 0,1,2,5,76,8980,9917,9921 8

6 0,1,2,5,76,8980,9933 7

7 0,1,2,5,76,8980,9933,9934 8

7 0,1,2,5,76,8980,9933,9935 8

7 0,1,2,5,76,8980,9933,9936 8

7 0,1,2,5,76,8980,9933,9937 8

6 0,1,2,5,76,8980,9949 7

7 0,1,2,5,76,8980,9949,9950 8

7 0,1,2,5,76,8980,9949,9951 8

6 0,1,2,5,76,8981,9965 7

7 0,1,2,5,76,8981,9965,9966 8

7 0,1,2,5,76,8981,9965,9967 8

7 0,1,2,5,76,8981,9965,9968 8

7 0,1,2,5,76,8981,9965,9969 8

7 0,1,2,5,76,8981,9965,9970 8

7 0,1,2,5,76,8981,9965,9971 8

6 0,1,2,5,76,8984,10349 7

7 0,1,2,5,76,8984,10349,10350 8

7 0,1,2,5,76,8984,10349,10352 8

7 0,1,2,5,76,8984,10349,10353 8

7 0,1,2,5,76,8984,10349,10354 8

7 0,1,2,5,73,16122,16891,16892 8

7 0,1,2,5,73,16122,16891,16893

------------正 文 已 结 束， 感 谢 您 的 阅 读 (折雨的天空)--------------------