简单点的
UPDATE T_CONT_TRANSFEROTHERFEE T
SET (T.VERIFICATION_FEE_AMOUNT, T.MODIFY_ID ,T.MODIFY_TIME ) =
(SELECT T1.VERIFICATION_FEE_AMOUNT , 5 ,SYSDATE
FROM T_FUND_OTHERFEEPAIDDETAIL T1
WHERE T1.TRANS_OTHERID = T.ID AND T1.OTHERPAID_ID =7 )
WHERE EXISTS (
SELECT 1
FROM T_FUND_OTHERFEEPAIDDETAIL T1
WHERE T1.TRANS_OTHERID = T.ID AND
T1.OTHERPAID_ID =7
)
复杂一点的
update liulangyu_examineedetail t set (t.exam_card_num,t.status) =
(SELECT zk_code, 220
FROM
(SELECT zk_uuid, zk_code
FROM (select examineedetail.uuid zk_uuid,
to_char(worktype.EXAM_DATE, 'yyMMdd') || '01' ||
decode(substr(examineedetail.EXAMAREA_UUID, 0, 3),
'010',
substr(examineedetail.EXAMAREA_UUID, 4),
substr(examineedetail.EXAMAREA_UUID, 0, 3)) ||
EXAMPOINT_INFO.EP_CODE || CLASSROOM.CLASS_SEQ ||
examineedetail.seat_num zk_code
from liulangyu_examineedetail examineedetail,
liulangyu_planinfo planinfo,
liulangyu_worktype worktype,
liulangyu_EXAMPOINT_INFO EXAMPOINT_INFO,
liulangyu_CLASSROOM CLASSROOM
where examineedetail.PLAN_UUID = planinfo.uuid
and examineedetail.ENROLL_LEVEL_UUID = worktype.uuid
and examineedetail.ep_uuid = EXAMPOINT_INFO.Uuid
and examineedetail.class_uuid = CLASSROOM.Uuid
and examineedetail.status=210
and planinfo.uuid = 'cbaa6d10-68a6-4ac2-8932-dd87c00f16fd'))
zk
where t.uuid = zk.zk_uuid)
where t.plan_uuid = 'cbaa6d10-68a6-4ac2-8932-dd87c00f16fd'
and exists(select 1
FROM
(SELECT zk_uuid, zk_code
FROM (select examineedetail.uuid zk_uuid,
to_char(worktype.EXAM_DATE, 'yyMMdd') || '01' ||
decode(substr(examineedetail.EXAMAREA_UUID, 0, 3),
'010',
substr(examineedetail.EXAMAREA_UUID, 4),
substr(examineedetail.EXAMAREA_UUID, 0, 3)) ||
EXAMPOINT_INFO.EP_CODE || CLASSROOM.CLASS_SEQ ||
examineedetail.seat_num zk_code
from liulangyu_examineedetail examineedetail,
liulangyu_planinfo planinfo,
liulangyu_worktype worktype,
liulangyu_EXAMPOINT_INFO EXAMPOINT_INFO,
liulangyu_CLASSROOM CLASSROOM
where examineedetail.PLAN_UUID = planinfo.uuid
and examineedetail.ENROLL_LEVEL_UUID = worktype.uuid
and examineedetail.ep_uuid = EXAMPOINT_INFO.Uuid
and examineedetail.class_uuid = CLASSROOM.Uuid
and examineedetail.status=210
and planinfo.uuid = 'cbaa6d10-68a6-4ac2-8932-dd87c00f16fd'))
zk2
where t.uuid = zk2.zk_uuid);
update liulangyu_scoreinfo t set (t.exam_card_num) =
(SELECT zk_code
FROM
(SELECT zk_uuid, zk_code
FROM (select examineedetail.uuid zk_uuid,
to_char(worktype.EXAM_DATE, 'yyMMdd') || '01' ||
decode(substr(examineedetail.EXAMAREA_UUID, 0, 3),
'010',
substr(examineedetail.EXAMAREA_UUID, 4),
substr(examineedetail.EXAMAREA_UUID, 0, 3)) ||
EXAMPOINT_INFO.EP_CODE || CLASSROOM.CLASS_SEQ ||
examineedetail.seat_num zk_code
from liulangyu_examineedetail examineedetail,
liulangyu_planinfo planinfo,
liulangyu_worktype worktype,
liulangyu_EXAMPOINT_INFO EXAMPOINT_INFO,
liulangyu_CLASSROOM CLASSROOM
where examineedetail.PLAN_UUID = planinfo.uuid
and examineedetail.ENROLL_LEVEL_UUID = worktype.uuid
and examineedetail.ep_uuid = EXAMPOINT_INFO.Uuid
and examineedetail.class_uuid = CLASSROOM.Uuid
and examineedetail.status=220
and planinfo.uuid = 'cbaa6d10-68a6-4ac2-8932-dd87c00f16fd'))
zk
where t.examinee_uuid = zk.zk_uuid)
where t.plan_uuid = 'cbaa6d10-68a6-4ac2-8932-dd87c00f16fd'
and exists(select 1
FROM
(SELECT zk_uuid, zk_code
FROM (select examineedetail.uuid zk_uuid,
to_char(worktype.EXAM_DATE, 'yyMMdd') || '01' ||
decode(substr(examineedetail.EXAMAREA_UUID, 0, 3),
'010',
substr(examineedetail.EXAMAREA_UUID, 4),
substr(examineedetail.EXAMAREA_UUID, 0, 3)) ||
EXAMPOINT_INFO.EP_CODE || CLASSROOM.CLASS_SEQ ||
examineedetail.seat_num zk_code
from liulangyu_examineedetail examineedetail,
liulangyu_planinfo planinfo,
liulangyu_worktype worktype,
liulangyu_EXAMPOINT_INFO EXAMPOINT_INFO,
liulangyu_CLASSROOM CLASSROOM
where examineedetail.PLAN_UUID = planinfo.uuid
and examineedetail.ENROLL_LEVEL_UUID = worktype.uuid
and examineedetail.ep_uuid = EXAMPOINT_INFO.Uuid
and examineedetail.class_uuid = CLASSROOM.Uuid
and examineedetail.status=220
and planinfo.uuid = 'cbaa6d10-68a6-4ac2-8932-dd87c00f16fd'))
zk2
where t.examinee_uuid = zk2.zk_uuid);