select f.id, f.content, instr(f.content,‘2’,1) as position, f.type, TO_CHAR(f.create_date,‘yyyy-MM-dd HH24:mi:ss’) create_date, f.RW
from (select t.id, t.content, t.type, t.create_date, rownum RW
from DDM_IM_DISABLE_THESAURUS t where t.content like ‘%2%’ ) f order by position
ORACLE模糊查询按照关键字出现的位置排序
最新推荐文章于 2021-04-03 05:18:43 发布