-- ORACLE 更新表数据10GUPDATE (SELECT /*+ BYPASS_UJVC */ A.SSXID, A.SSZ, A.SSZID FROM P_ZJ_CZDDW A, (SELECT C.ID, C.ND, C.SSQCODE, C.SSDD, C.SSDDCODE FROM P_ZJ_SJSB C WHERE C.DEL_FLAG = '0') BWHERE A.FPID = B.ID AND A.ND = B.ND AND A.DEL_FLAG = '0') SET A.SSXID = B.SSQCODE, A.SSZ = B.SSDD, A.SSZID = B.SSDDCODE;COMMIT;
-- ORACLE 更新表数据11G
MERGE /*+ PARALLEL */ INTO P_ZJ_CZDDW AUSING (SELECT ID, ND, SSQCODE, SSDD, SSDDCODE FROM P_ZJ_SJSB WHERE DEL_FLAG = '0') BON (A.FPID = B.ID AND A.ND = B.ND AND A.DEL_FLAG = '0')WHEN MATCHED THENUPDATE SET A.SSXID = B.SSQCODE, A.SSZ = B.SSDD, A.SSZID = B.SSDDCODE;COMMIT;
转载于:https://www.cnblogs.com/Dream-Lasting/p/8991041.html
相关资源：JAVA上百实例源码以及开源项目