select (length('oracle11g, oracle10g oracle9i | oracle8i') -
length(replace('oracle11g, oracle10g oracle9i | oracle8i',
'oracle',
'')))/length('oracle') string_count from dual;
length(replace('oracle11g, oracle10g oracle9i | oracle8i',
'oracle',
'')))/length('oracle') string_count from dual;