Code select length('strtest')-length(replace('strtest','t')) from dual; 转载于:https://www.cnblogs.com/libiao/archive/2008/12/23/1360684.html