oracle模糊查询(单个字段返回的多个值),得到其各个值以及对应的各个值的子数据 select * from table a exists (select * from table t where t.cidlj in (1,2,3)and a.cidlj like t.cidlj ||’%’)