exists

UPDATE IC_HRORG_RAW_DATA T SET F_LEAF= 0  where  exists(select * from IC_HRORG_RAW_DATA U where U.F_GZBM_id != T.F_GZBM_id AND U.F_GZBM_ID LIKE T.F_GZBM_ID ||'%' ); 

UPDATE IC_HRORG_RAW_DATA T SET F_PARENT= 0  where  exists(select * from IC_HRORG_RAW_DATA U where U.F_GZBM_id != T.F_GZBM_id AND U.F_GZBM_ID LIKE T.F_GZBM_ID ||'%' ); 

 

 

 

SELECT F_LINKID FROM BF_ORG_MGR B WHERE   not exists  (
SELECT F_GZBM_ID FROM ic_hrorg A WHERE A.F_GZBM_ID =B.F_LINKID AND B.f_id  like '02%')
AND f_id  like '02%'---29

 

 

oracle数据库中查询一个表中的字段是否存在于另一个表中字段数据

select distinct(a.adcd),a.adnm from fda.ia_adc_adinfo a where not exists(select * from mde.sys_adcdyear b  where  a.adcd=b.code)  and  substr(a.adcd,5,2)!='00' and substr(a.adcd,7,15)='000000000'

验证ia_adc_adinfo表中adcd,adnm字段中数据是否在sys_adcdyear表中存在，其中adcd=code
--------------------- 
作者：失独者 
来源：CSDN 
原文：https://blog.csdn.net/luwei_cool/article/details/51810036