请忽略表名,领会思想
BEGIN
FOR L_RECORD IN (SELECT *
FROM "E_TJCRM_FINE_ACCEXPAND" tjcrm
INNER JOIN "E_FINEGRAINED_ACCOUNT" acc ON acc.uuid = tjcrm.ACCUUID
WHERE acc.resnum = 'BICP') LOOP
UPDATE "E_TJCRM_FINE_ACCEXPAND"
SET PERSONUUID = ( SELECT rel.personuuid
FROM e_oper_authz_resacc_rel rel
INNER JOIN org_subacc sub ON sub.subacc_uuid = rel.resaccuuid
INNER JOIN E_AppResource app ON app.resuuid = sub.resuuid
WHERE rel.RESACCUUID = L_RECORD.ACCUUID
AND ROWNUM = 1)
WHERE ACCUUID = L_RECORD.ACCUUID;
END LOOP;
END;