SELECT (LENGTHB('where trim where wherewhere')-LENGTHB(REPLACE('where trim where wherewhere','where',null)))/length('where') FROM DUAL;
oracle统计字符串出现次数
最新推荐文章于 2021-04-09 02:11:24 发布
SELECT (LENGTHB('where trim where wherewhere')-LENGTHB(REPLACE('where trim where wherewhere','where',null)))/length('where') FROM DUAL;