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
------------正 文 已 结 束， 感 谢 您 的 阅 读 （折雨的天空）--------------------
转载请注明本文标题和链接：《oracle统计某个字符在字段中出现的次数》
发表评论