SELECT (LENGTHB('where trim where wherewhere')-LENGTHB(REPLACE('where trim where wherewhere','where',null)))/length('where') FROM DUAL;
oracle统计字符串出现次数
最新推荐文章于 2023-11-21 17:12:46 发布
SELECT (LENGTHB('where trim where wherewhere')-LENGTHB(REPLACE('where trim where wherewhere','where',null)))/length('where') FROM DUAL;