SELECT length(regexp_replace('112122sasd1','[^1]','')) FROM dual output: 4 转载于:https://www.cnblogs.com/weiweiqingfeng/p/3921941.html