select id, name from TAB_A t where not exists (select 1 from TAB_B t1 where t.id = t1.id and t.name = t1.name)
Oracle 验证A表的2个字段组合不在B表2个字段组合里的数据
原文：http://www.cnblogs.com/wdw31210/p/4118180.html
