Find word count from string

select (length('mmohsamohsdmohsg')-length(replace('mmohsamohsdmohsg','mohs',''))) / length('mohs') from dual;