67,513
社区成员
发帖
与我相关
我的任务
分享
with tab1 as (
select '111' id from dual union all
select '1121' id from dual union all
select '1131' id from dual
),
tab2 as (
select '111' id from dual union all
select '121' id from dual union all
select '11331' id from dual
)
select * from tab1 t1
where not exists(
select 1 from tab2 t2 where instr(t1.id, t2.id) > 0
)
;