insert into A select * from B where not exists (select 1 from A where A.ID=B.ID)
insert when (not exists (select 1 from表名where 检验重复的条件)) then into表名values(相应的值)select 1 from dual
<wbr></wbr>insert into A select * from B where not exists (select 1 from A where A.ID=B.ID)
insert when (not exists (select 1 from表名where 检验重复的条件)) then into表名values(相应的值)select 1 from dual
<wbr></wbr>