for循环语句插入语句
begin
for p_uw_condition in (select tr.riskcode
from pub_risk tr
where tr.validind = '1'
and tr.riskcode not in
(select t.riskcode
from PUB_Code_Risk t
where 1 = 1
AND (VALIDIND = '1')
AND (COMPANYCODE = '01')
AND (CODETYPE = 'ClaimDocumentType')
AND t.codecode = 'A000'))

loop
-- 获取预付所有的险种及模板信息
for c_uw_condition in (select t.*
from PUB_Code_Risk t
where 1 = 1
AND (VALIDIND = '1')
AND (COMPANYCODE = '01')
AND (CODETYPE = 'ClaimDocumentType')
AND t.codecode = 'A000'
and t.riskcode = '1401') loop

c_uw_condition.riskcode := p_uw_condition.riskcode ;

insert into PUB_Code_Risk values c_uw_condition;

end loop;
end loop;

end ;