oracle数据库循环更新数据--实例

请忽略表名，领会思想

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;