查询字符串中某字符出现次数
select length(regexp_replace(replace(’#@@#rrrr#@@#’, ‘#@@#’, ‘|’), ‘[^|]+’, ‘’)) as COUNT
,replace(’#@@#rrrr#@@#’, ‘#@@#’, ‘|’)
,regexp_replace(’|rrrr|’, ‘[^|]+’, ‘’)
from dual
select length(regexp_replace(replace(’#@@#rrrr#@@#’, ‘#@@#’, ‘|’), ‘[^|]+’, ‘’)) as COUNT
,replace(’#@@#rrrr#@@#’, ‘#@@#’, ‘|’)
,regexp_replace(’|rrrr|’, ‘[^|]+’, ‘’)
from dual