批量更新记录sql

简单点的

UPDATE T_CONT_TRANSFEROTHERFEE TSET (T.VERIFICATION_FEE_AMOUNT, T.MODIFY_ID ,T.MODIFY_TIME ) &＃61;(SELECT T1.VERIFICATION_FEE_AMOUNT , 5 ,SYSDATE FROM T_FUND_OTHERFEEPAIDDETAIL T1WHERE T1.TRANS_OTHERID &＃61; T.ID AND T1.OTHERPAID_ID &＃61;7 )
WHERE EXISTS (SELECT 1 FROM T_FUND_OTHERFEEPAIDDETAIL T1WHERE T1.TRANS_OTHERID &＃61; T.ID AND T1.OTHERPAID_ID &＃61;7
)

复杂一点的

update liulangyu_examineedetail t set (t.exam_card_num,t.status) &＃61;
(SELECT zk_code, 220FROM(SELECT zk_uuid, zk_codeFROM (select examineedetail.uuid zk_uuid,to_char(worktype.EXAM_DATE, &＃39;yyMMdd&＃39;) || &＃39;01&＃39; ||decode(substr(examineedetail.EXAMAREA_UUID, 0, 3),&＃39;010&＃39;,substr(examineedetail.EXAMAREA_UUID, 4),substr(examineedetail.EXAMAREA_UUID, 0, 3)) ||EXAMPOINT_INFO.EP_CODE || CLASSROOM.CLASS_SEQ ||examineedetail.seat_num zk_codefrom liulangyu_examineedetail examineedetail,liulangyu_planinfo planinfo,liulangyu_worktype worktype,liulangyu_EXAMPOINT_INFO EXAMPOINT_INFO,liulangyu_CLASSROOM CLASSROOMwhere examineedetail.PLAN_UUID &＃61; planinfo.uuidand examineedetail.ENROLL_LEVEL_UUID &＃61; worktype.uuidand examineedetail.ep_uuid &＃61; EXAMPOINT_INFO.Uuidand examineedetail.class_uuid &＃61; CLASSROOM.Uuidand examineedetail.status&＃61;210and planinfo.uuid &＃61; &＃39;cbaa6d10-68a6-4ac2-8932-dd87c00f16fd&＃39;))zkwhere t.uuid &＃61; zk.zk_uuid)
where t.plan_uuid &＃61; &＃39;cbaa6d10-68a6-4ac2-8932-dd87c00f16fd&＃39;
and exists(select 1FROM
(SELECT zk_uuid, zk_codeFROM (select examineedetail.uuid zk_uuid,to_char(worktype.EXAM_DATE, &＃39;yyMMdd&＃39;) || &＃39;01&＃39; ||decode(substr(examineedetail.EXAMAREA_UUID, 0, 3),&＃39;010&＃39;,substr(examineedetail.EXAMAREA_UUID, 4),substr(examineedetail.EXAMAREA_UUID, 0, 3)) ||EXAMPOINT_INFO.EP_CODE || CLASSROOM.CLASS_SEQ ||examineedetail.seat_num zk_codefrom liulangyu_examineedetail examineedetail,liulangyu_planinfo planinfo,liulangyu_worktype worktype,liulangyu_EXAMPOINT_INFO EXAMPOINT_INFO,liulangyu_CLASSROOM CLASSROOMwhere examineedetail.PLAN_UUID &＃61; planinfo.uuidand examineedetail.ENROLL_LEVEL_UUID &＃61; worktype.uuidand examineedetail.ep_uuid &＃61; EXAMPOINT_INFO.Uuidand examineedetail.class_uuid &＃61; CLASSROOM.Uuidand examineedetail.status&＃61;210and planinfo.uuid &＃61; &＃39;cbaa6d10-68a6-4ac2-8932-dd87c00f16fd&＃39;))zk2where t.uuid &＃61; zk2.zk_uuid);update liulangyu_scoreinfo t set (t.exam_card_num) &＃61;
(SELECT zk_codeFROM(SELECT zk_uuid, zk_codeFROM (select examineedetail.uuid zk_uuid,to_char(worktype.EXAM_DATE, &＃39;yyMMdd&＃39;) || &＃39;01&＃39; ||decode(substr(examineedetail.EXAMAREA_UUID, 0, 3),&＃39;010&＃39;,substr(examineedetail.EXAMAREA_UUID, 4),substr(examineedetail.EXAMAREA_UUID, 0, 3)) ||EXAMPOINT_INFO.EP_CODE || CLASSROOM.CLASS_SEQ ||examineedetail.seat_num zk_codefrom liulangyu_examineedetail examineedetail,liulangyu_planinfo planinfo,liulangyu_worktype worktype,liulangyu_EXAMPOINT_INFO EXAMPOINT_INFO,liulangyu_CLASSROOM CLASSROOMwhere examineedetail.PLAN_UUID &＃61; planinfo.uuidand examineedetail.ENROLL_LEVEL_UUID &＃61; worktype.uuidand examineedetail.ep_uuid &＃61; EXAMPOINT_INFO.Uuidand examineedetail.class_uuid &＃61; CLASSROOM.Uuidand examineedetail.status&＃61;220and planinfo.uuid &＃61; &＃39;cbaa6d10-68a6-4ac2-8932-dd87c00f16fd&＃39;))zkwhere t.examinee_uuid &＃61; zk.zk_uuid)
where t.plan_uuid &＃61; &＃39;cbaa6d10-68a6-4ac2-8932-dd87c00f16fd&＃39;
and exists(select 1FROM(SELECT zk_uuid, zk_codeFROM (select examineedetail.uuid zk_uuid,to_char(worktype.EXAM_DATE, &＃39;yyMMdd&＃39;) || &＃39;01&＃39; ||decode(substr(examineedetail.EXAMAREA_UUID, 0, 3),&＃39;010&＃39;,substr(examineedetail.EXAMAREA_UUID, 4),substr(examineedetail.EXAMAREA_UUID, 0, 3)) ||EXAMPOINT_INFO.EP_CODE || CLASSROOM.CLASS_SEQ ||examineedetail.seat_num zk_codefrom liulangyu_examineedetail examineedetail,liulangyu_planinfo planinfo,liulangyu_worktype worktype,liulangyu_EXAMPOINT_INFO EXAMPOINT_INFO,liulangyu_CLASSROOM CLASSROOMwhere examineedetail.PLAN_UUID &＃61; planinfo.uuidand examineedetail.ENROLL_LEVEL_UUID &＃61; worktype.uuidand examineedetail.ep_uuid &＃61; EXAMPOINT_INFO.Uuidand examineedetail.class_uuid &＃61; CLASSROOM.Uuidand examineedetail.status&＃61;220and planinfo.uuid &＃61; &＃39;cbaa6d10-68a6-4ac2-8932-dd87c00f16fd&＃39;))zk2where t.examinee_uuid &＃61; zk2.zk_uuid);