日期:2014-05-17 浏览次数:20822 次
delete from call c
where c.calling_nbr not in (select nbr from user_info)
and c.called_nbr not in (select nbr from user_info);
delete /*+ parallel(a,32) */from call a
where exists(select 1
from user_info b
where b.nbr in (a.calling_nbr ,a.called_nbr)
);