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