create cursor …… begin fetch …… in …… open c1 …… end ……;
成批插入:建议分批插入 删除相同记录: 假如你的保单表中的field1,field2相同就可以确定同一条记录delete from policy cc where exists (select 1 from ( select max(id),field1,field2 from ( select aa.id id,aa.field1 field1,aa.field2 field2 from policy aa where exists ( select 1 from policy bb where aa.field1=bb.field1 and aa.field2=bb.field2 and aa.id<>bb.id )order by aa.field1,aa.field2 )group by field1,field2 )kk where kk.filed1==cc.field1 and kk.field2=cc.field2 and kk.id<>cc.id )
删除掉重复记录,确保 P_1字段的数据在policy表中是惟一的
begin
fetch …… in ……
open c1
……
end ……;
删除相同记录:
假如你的保单表中的field1,field2相同就可以确定同一条记录delete from policy cc
where exists
(select 1 from
(
select max(id),field1,field2 from
(
select aa.id id,aa.field1 field1,aa.field2 field2 from policy aa
where exists
(
select 1 from policy bb
where aa.field1=bb.field1 and aa.field2=bb.field2 and aa.id<>bb.id
)order by aa.field1,aa.field2
)group by field1,field2
)kk
where kk.filed1==cc.field1 and kk.field2=cc.field2 and kk.id<>cc.id
)