17,140
社区成员




with a as
(select 1 ID, 'abcd' NAME
from dual
union all
select 2 ID, 'bcde' NAME
from dual
union all
select 3 ID, 'cdef' NAME
from dual
union all
select 4 ID, 'defg' NAME from dual
)
select a.* from a where instr('abcdef', name) > 0