ORACLE查询某字符在字符串中出现次数

select length(regexp_replace(replace("ORACLE查询某字符在字符串中出现次数", "字符", "|"),  "[^|]+",  "")) as COUNT from dual;